Skip to content

Registered aircraft · 54,015

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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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.

N66147Leckman Richard · Sequim, WABuilt 1974 · S/N 15075870 N66148Hooie Jon Paul D · N Fort Myers, FLBuilt 1974 · S/N 15075871 N6614AHanks Mitchell L · Carthage, ILS/N 28714 N6614GDonaldson Charles R · Marfa, TXS/N 15072114 N6614MSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1975 · S/N 18263778 N6614VThomas Anna D · Kiana, AKS/N 172RG0782 N6614YBoots LLC · Clay Center, KSS/N 21064460 N66152Aeromarine Airways Inc · Miami, FLBuilt 1974 · S/N 15075875 N66154Registration Pending · Bandon, ORRegistration pendingBuilt 1974 · S/N 15075877 N66156Mount Crillon LLC · Juneau, AKBuilt 1977 · S/N 18052919 N66157Respess Malvin R · Pantego, NCBuilt 1974 · S/N 15075880 N66158Sublett Timothy M · Raleigh, NCBuilt 1974 · S/N 15075881 N66159Ard Terry D · Mount Vernon, IABuilt 1974 · S/N 15075882 N6615DCivil Air Patrol Inc · Montgomery, ALBuilt 1979 · S/N 17272902 N6615EBranstner August M · Taft, CABuilt 1959 · S/N 56115 N6615NTexas Skyways Research & Development · Boerne, TXBuilt 1981 · S/N 18267845 N6615SStott Thomas W · Fort Shaw, MTBuilt 1967 · S/N 15067415 N66164Best Myra J · Sullivan, OHBuilt 1974 · S/N 15075886 N66168C P Aviation · Santa Paula, CABuilt 1983 · S/N 17275974 N6616DMjng Investment Group LLC · Melbourne, FLBuilt 1979 · S/N 17272903 N6616EBurger Rodney K · Monroe, UTBuilt 1959 · S/N 56116 N6616GSale Reported · Pineville, LASale reported, pending cancellationS/N 15072116 N6616HBurke Anthony · Poughkeepsie, NYBuilt 1975 · S/N 17265511 N66173Crawford Derrell D · Hot Springs, ARBuilt 1974 · S/N 15075894 N66174Pea-Wayman Flight LLC · Daytona Beach, FLS/N 17275975 N66178Allison Christopher D · Pensacola, FLBuilt 1974 · S/N 15075898 N6617CN6617c Inc · Calumet City, ILBuilt 1980 · S/N 21063933 N6617ELinstad Daniel Elmer · Canby, ORBuilt 1978 · S/N 17272045 N6617GGeneral Aviation Holdings LLC · Port Orange, FLBuilt 1970 · S/N 15072117 N6617HNorth Franklin County Flying Club · North Lawrence, NYBuilt 1975 · S/N 17265512 N6617JJeffries Holdings LLC · Bargersville, INBuilt 1980 · S/N 17273900 N6617SKembel Robert D · Saint Ignatius, MTS/N 15067417 N66181Adr Aircraft Service Inc · Burbank, CABuilt 1974 · S/N 15075900 N66182Naples Seaplane Adventures LLC · Denmark, MEBuilt 1978 · S/N 18052923 N66186Rybak David J Sr · Lino Lakes, MNS/N 18052924 N66188Mcghie John · Concord, NHBuilt 1974 · S/N 15075906 N66189Skynick Enterprises Inc · Tarzana, CABuilt 1983 · S/N 17275976 N6618DStein Air LLC · New Ringgold, PABuilt 1979 · S/N 17272905 N6618EWilson Eliott R · Gallipolis, OHBuilt 1959 · S/N 56118 N6618GKonkle Tyrel J · Morristown, TNBuilt 1970 · S/N 15072118 N6618SLipski Robert · Wallingford, CTBuilt 1967 · S/N 15067418 N6618VLang Gerald K · Baker, MTBuilt 1980 · S/N 172RG0783 N6618XRoark Ken W · Cisco, TXS/N 21057618 N66192Roberts John G · Brandon, MSBuilt 1974 · S/N 15075909 N66194Holmes Community College · Goodman, MSBuilt 1974 · S/N 15075910 N66195Sockey Investments LLC · Poteau, OKBuilt 1974 · S/N 15075911 N66197Williams Freddy L Jr · Apo, AEBuilt 1974 · S/N 15075912 N66199Cunningham Chris S · Hiram, GABuilt 1974 · S/N 15075914 N6619ATest Jeffrey T · Port Charlotte, FLBuilt 1956 · S/N 28719 N6619DBannwart Justin S · North Liberty, INBuilt 1979 · S/N 17272906

Back to AD 87-20-03 R2