Registered aircraft · 20,481

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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.

N7711DCaldwell Joel A · Kenai, AKBuilt 1976 · S/N U206-03170 N7712AMizer James D · Hailey, IDFirst renewal noticeBuilt 1956 · S/N 32609 N7714ALawyers Real Estate Services LLC · Hondo, NMBuilt 1956 · S/N 32611 N7715AWallace Wayne P · Graham, WABuilt 1956 · S/N 32612 N7715KDutch Air LLC · Kalispell, MTBuilt 1976 · S/N 18052708 N77182Magro Daniel L Sr · Piperton, TNS/N 182-65921 N77185Carter Danny · Baxley, GABuilt 1973 · S/N 18261744 N771CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281781 N771EEBtr Inc · Chula Vista, CAS/N 18254542 N771KKnutson Aviation Inc · Cedar Hill, TXBuilt 1977 · S/N 18052899 N771KCAkin John · Highland, CABuilt 1975 · S/N 18264033 N771TMMid-South Aviation LLC · Caruthersville, MOBuilt 2011 · S/N 18282286 N77206Venture Alaska LLC · Homer, AKBuilt 1977 · S/N U20603771 N7720AKrueger Eric J · Olivehurst, CABuilt 1956 · S/N 32617 N7721AAngel Steven · Fairbanks, AKBuilt 1956 · S/N 32618 N7722FSmall Tony D · Welch, OKBuilt 1972 · S/N 18261560 N7723ADoremus Scott M · Wolfeboro, NHBuilt 1956 · S/N 32620 N7723MDdw Inc · Gardner, COBuilt 1968 · S/N T210-0357 N7724KGardner Thomas W · Lincoln, MEBuilt 1976 · S/N 18052711 N772CGBarefoot Brendan · Four Oaks, NCBuilt 1973 · S/N 18261964 N772PLSfc-182 LLC · Kansas City, MOBuilt 1965 · S/N 18255970 N772RFSpencer John S · Indian, AKBuilt 1967 · S/N U206-0816 N772TXDyson Thornton E · Houston, TXBuilt 1979 · S/N 18267491 N7731KMorrison Richard Trustee · Anchorage, AKBuilt 1976 · S/N 18052712 N773DSHotchkiss Anita E · Cody, WYBuilt 1973 · S/N 18262402 N773DWWalerius Dennis · Sylvania, OHBuilt 1976 · S/N U20603202 N773PAir Data Solutions LLC · Natchitoches, LABuilt 1964 · S/N U206-0309 N773TFRivergates Ivy Aviation LLC · Boca Raton, FLBuilt 2017 · S/N 18283004 N773TTTim Twisselman Enterprises Inc · San Luis Obispo, CABuilt 2021 · S/N 18283124 N7741ATalaheim Air Service LLC · Willow, AKBuilt 1956 · S/N 32638 N7743AHarden Harry B · English, INBuilt 1956 · S/N 32640 N7743GVaughn Investment Services LLC · New Plymouth, IDS/N 57046 N7746GMissionaire · Temple, TXBuilt 1974 · S/N 18263328 N7749APrins Dennis A · South Lake Tahoe, CAS/N 32646 N7749KParshall Stephen T · Olympia, WABuilt 1976 · S/N 18052717 N774CFApperson Aviation LLC · Palm City, FLBuilt 2017 · S/N 18283021 N774CPCivil Air Patrol · Montgomery, ALBuilt 2010 · S/N 18282257 N774CSWyo Ventures LLC · Buffalo, WYBuilt 1976 · S/N 21061359 N774JA&A Airlines LLC · New Boston, NHBuilt 1974 · S/N 18262887 N774MCDe Camargo Marcelo A · Richmond, TXBuilt 1976 · S/N 18264897 N774RDDemuth Roger C Trustee · Valley View, TXBuilt 1974 · S/N 21060229 N774TMVan Bortel Aircraft Inc · Arlington, TXBuilt 2019 · S/N 18283088 N7751KKyer Barry P · Honey Grove, TXBuilt 1976 · S/N 18052719 N77554U S Department Of The Interior · Boise, IDBuilt 1976 · S/N U20603408 N7755ADunn Brian R · Otis, MEBuilt 1956 · S/N 32652 N7757CBentley John R · Bend, ORBuilt 1961 · S/N 30389 N775AVintage Air LLC · Brighton, MIBuilt 1951 · S/N 7631 N775CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281779 N775MRTorres Kim Renee · Castroville, TXS/N 18281073 N775PSkydive Seneca Lake LLC · Ovid, NYBuilt 1966 · S/N U206-0769

Back to AD 84-10-01 R1