Skip to content

Registered aircraft · 1,889

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:95-19-15-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-19-15-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:95-19-15-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-19-15-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:95-19-15-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-19-15-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N468BCHot Wings Flying Club LLC · Portland, ORBuilt 1975 · S/N AA5B0195 N46YMAircraft Partner Holdings Inc Trustee · BerlinBuilt 1992 · S/N 10026 N475KKmt Aviation LLC · Centerville, OHBuilt 1978 · S/N AA5A0667 N477BGParker Dennis A · Charlevoix, MIBuilt 1977 · S/N AA5A0364 N4783PBush Robert Edward · Mead, WABuilt 1977 · S/N AA5B-0526 N47PGRandall Skye Sanjay · Lansdowne, PABuilt 1977 · S/N AA5A0340 N48ERChess Group LLC · Minden, LABuilt 1978 · S/N AA5B0906 N48WLAtkinson Matthew D · Theodore, ALBuilt 1978 · S/N AA5B0892 N492LGSunday Punchers LLC · Monrovia, INBuilt 1979 · S/N AA5A0887 N498THInterstellar Vc LLC · New York, NYBuilt 1978 · S/N AA5A0611 N49948Stuart George G · Maceo, KYBuilt 1975 · S/N AA5A-0046 N499GTEast & West Aviation LLC · Valdosta, GABuilt 1977 · S/N AA5B-0499 N49GTKugielsky Benjamin W · Newtown, CTBuilt 1975 · S/N AA5B-0116 N49THaas Jeffrey B · Hudson, NCBuilt 1975 · S/N AA5A-0021 N4KGYoung Randall K · Clearwater Beach, FLBuilt 1977 · S/N AA5B0454 N505Lawson Jesse James · Placerville, CABuilt 1979 · S/N AA5B1275 N50BXAthena Aviation LLC · Greenville, SCBuilt 2003 · S/N 10227 N50ERFisher-Smith Jotham · Soquel, CABuilt 1978 · S/N AA5B0908 N50FABeck Frank · Arvada, COBuilt 1972 · S/N AA5-154 N50PJPremier Jets Inc · Hillsboro, ORBuilt 1976 · S/N AA5B-0287 N51012Better Connect Systems LLC · Manheim, PABuilt 1973 · S/N AA5-0495 N511DMCapron Robert S · Seneca, SCBuilt 1992 · S/N 10102 N512BWMontauk Catamaran Co LLC · Montauk, NYBuilt 1974 · S/N AA5-0702 N513GTDillon Michael C · Midlothian, TXBuilt 1977 · S/N AA5B0655 N513RMRosen Larry M Trustee · Santa Barbara, CABuilt 1977 · S/N AA5B0458 N515SRGifford Daniel · Fredericksburg, TXS/N AA5A-0799 N51687Ambron Trevor L · Valdosta, GABuilt 1978 · S/N AA5B-0857 N51790Tartock Russell L · Salisbury, NCBuilt 1979 · S/N AA5A-0850 N518PLMoore David P Trustee · Chattanooga, TNBuilt 1975 · S/N AA5B-0144 N51BBOlivo Ashton Mars · Inwood, NYBuilt 1976 · S/N AA5A-0150 N51VKGaudreau Henry J · Chesaning, MIBuilt 1975 · S/N AA5B-0174 N521TTCaras Tiger LLC · Homestead, FLS/N 10128 N528CCPositive Attitudes Of Zephyrhills LLC · Zephyrhills, FLBuilt 1972 · S/N AA5-0149 N52ERFly Safe Southwest LLC · Vail, AZBuilt 1979 · S/N AA5B1095 N534MPJones David C · Williston, VTBuilt 1991 · S/N 10066 N53GTRogers Frank B III · Blenheim, SCS/N AA5B-0843 N5400LKlicker William K · Poplar Grove, ILS/N AA5-0300 N5402LChomchird Attaporn J · Centreville, VABuilt 1973 · S/N AA5-0302 N5404LRegistered aircraftBuilt 1973 · S/N AA5-0304 N5405LScalia Dennis · Westlake, LAS/N AA5-0305 N5406LLone Roger D · Prosperity, SCBuilt 1973 · S/N AA5-0306 N5407LStech Stuart · Fredericksburg, TXBuilt 1973 · S/N AA5-0307 N5409LBarnhardt Robin J · Eleva, WIBuilt 1973 · S/N AA5-0309 N5412LTurner Donald W · Winston, GABuilt 1973 · S/N AA5-0312 N5414LDrake Dustin L · Hollywood, SCBuilt 1973 · S/N AA5-0314 N5415LMccasland Paul S · Lafayette, LAS/N AA5-0315 N5416LDawson Brian S · Andover, MABuilt 1973 · S/N AA5-0316 N5417LBarboza Scott M · Dighton, MABuilt 1973 · S/N AA5-0501 N5420LHughes Mormon Byrd · Rhome, TXBuilt 1974 · S/N AA5-0510 N5421LStanfill Michael O · Lucedale, MSS/N AA5-0321

Back to AD 95-19-15 R1