Registered aircraft · 72,007

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-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.

N2737JClair Brent · Loraine, ILBuilt 1979 · S/N 17273643 N2738TProtac Aviation LLC · Highland, CAFirst renewal noticeBuilt 1967 · S/N TD-693 N2738WMead James R · Jonesboro, ARFirst renewal noticeBuilt 1966 · S/N 260 N2739CLge Flying Club Inc · Marietta, GABuilt 1978 · S/N R18200223 N2739RPerrong Andrew R · Huntingdon Valley, PABuilt 1969 · S/N 28R-35279 N2739WKessler Henry L · San Gabriel, CABuilt 1966 · S/N 3344 N2739YEnnis Michael J · Eminence, MOBuilt 1958 · S/N TD-92 N273AAHammerschlag Richard S · Kamiah, IDBuilt 1959 · S/N TD-321 N273BGates Hiram P · Faribault, MNBuilt 1959 · S/N 131 N273BTN273bt Air LLC · Sweetser, INBuilt 1979 · S/N 27-7954112 N273CCRegenald Michaud Aviation LLC · Willows, CABuilt 2001 · S/N 9920CC N273EBNorth Country Aircraft Holdings LLC · Watertown, NYBuilt 1978 · S/N 17271018 N273FWeimer Heidi L · Knoxville, TNBuilt 1973 · S/N 32-7340138 N273JTros Corp · Wilmington, DEBuilt 2017 · S/N 1211 N273JFParrish Aviation Flight Academy LLC · Southlake, TXS/N 17261732 N273METopel Holdings LLC · Scottsdale, AZBuilt 2000 · S/N T20608217 N273MJSmith Jeffrey W · Shreveport, LABuilt 1979 · S/N 32R-7985065 N273NDPurdue Aviation LLC · West Lafayette, INBuilt 2000 · S/N 28-42073 N273RRJet Set Aircraft Inc · Van Nuys, CABuilt 1965 · S/N 27-3020 N273SBAero White LLC · Wheat Ridge, COBuilt 1997 · S/N 1615 N27405N27405 Holding LLC · Palm City, FLBuilt 1977 · S/N 31-7752164 N2740RRegistration Pending · Wilmington, DERegistration pendingS/N 28R-35280 N2740WBakewell Keith · Independence, LABuilt 1966 · S/N 1038 N27418Sun Aircraft Management LLC · Ormond Beach, FLS/N 31-7752169 N2741HEaa Aviation Foundation Inc · Oshkosh, WIBuilt 2014 · S/N 81180 N2741WEdison Robert J · Anchorage, AKBuilt 1966 · S/N 1039 N2741YCoelum LLC · Lake Mary, FLBuilt 1958 · S/N TD-94 N27423Kadrmas Arnold E · Lewiston, IDBuilt 1977 · S/N 31-7752173 N2742DLloyd Land Plane III LLC · Brighton, COBuilt 1952 · S/N 25284 N2742RCollinsworth Frederick W · Broken Arrow, OKBuilt 1969 · S/N 28R-35281 N2742WStraub R L DBA · Stanton, TXBuilt 1966 · S/N 1040 N2744Morgan Jeff P · Justin, TXBuilt 2017 · S/N 2883 N27446Evans William Henry Jr · Gardendale, TXBuilt 1939 · S/N 2088 N27447Laingkids LLC · Lewes, DEBuilt 1977 · S/N 31-7812022 N27449Airchoice LLC · Manchester, IABuilt 1977 · S/N 31-7812025 N2744CBrewer Farms · Thompson, MOBuilt 1978 · S/N R18200224 N2744JOvation Cwa LLC · Prairie Du Sac, WIBuilt 1979 · S/N 17273644 N2744VHerrenkohl Robert D · Bay Point, CAS/N 3346 N27450Flying Oyster Investments II LLC · Apollo Beach, FLBuilt 1977 · S/N 31-7812027 N2745MNfh Aviation LLC · Pikeville, KYBuilt 1999 · S/N 17280586 N2745PColgan Paulette · Tucson, AZBuilt 2010 · S/N 90142 N2745ZKlabunde Andrew G · Menasha, WIBuilt 1978 · S/N 357-78 N2746CChen Mark · Plano, TXBuilt 1998 · S/N 17280587 N2746PParish Brandon · Mendon, UTBuilt 1955 · S/N 22-3053 N2746YDavenport Jimmy J · Hayesville, NCBuilt 1958 · S/N TD-104 N27471Grant Aviation Inc · Anchorage, AKBuilt 1977 · S/N 31-7852018 N27478Hughes Ronnie D · Cedar Park, TXBuilt 1977 · S/N 31-7852026 N2747GVogt Mark Allen · San Diego, CABuilt 1967 · S/N 143 N2747PSvendsen Jon A · Wasilla, AKBuilt 1955 · S/N 22-3054 N2747RWilliams Dwight M · Paragould, ARS/N 18280343

Back to AD 87-10-06 R1