Registered aircraft · 20,483

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.

N2990CLyng Stephen G · Kenosha, WIBuilt 1954 · S/N 30890 N2990KGundersen Timothy A · Henderson, NVBuilt 1980 · S/N 18053153 N2991FBerryessa Alan E · Cedarville, CABuilt 1966 · S/N 18257091 N2991KHayton James B · Sedro Woolley, WAS/N 18053154 N2991YRabska William G · Suisun City, CABuilt 1962 · S/N 18253991 N2993CFrei Jayci N · Grangeville, IDS/N 30893 N2993FDaniels Aviation Inc · Inverness, MSS/N 18257093 N2993YBranch Robert W · Fort Mohave, AZS/N 18253993 N2994ADicicco Matthew Trustee · Los Gatos, CABuilt 1953 · S/N 30194 N2995FCj3 Aviation LLC · Idaho Falls, IDBuilt 1966 · S/N 18257095 N2996CSutton Aircraft Salvage LLC · Palmer, AKBuilt 1954 · S/N 30896 N2996FSmooth Air LLC · Mequon, WIBuilt 1966 · S/N 18257096 N2996YCrowe Timothy P · Gilbert, AZBuilt 1962 · S/N 18253996 N29970Andrecheck Cynthia R · Bethel, AKBuilt 1981 · S/N 185-04292 N29972Windblown Ranch Inc · Echo, ORBuilt 1981 · S/N 185-04162 N2997CSmith Philip W · Copeland, KSBuilt 1955 · S/N 30897 N2997YSkyriders LLC · Flagstaff, AZBuilt 1962 · S/N 18253997 N2998FChristian Halls International · Arlington, TXBuilt 1966 · S/N 18257098 N2998KWallingsford Don C · Yorba Linda, CABuilt 1980 · S/N 18053155 N2998YReynolds Peter · Athol, MABuilt 1962 · S/N 18253998 N2999AFindly Raymond Lee · Ravenna, KYBuilt 1953 · S/N 30199 N2999CCarnine Daniel L · Seeley Lake, MTBuilt 1954 · S/N 30899 N299PTWright W Gregory III · Kinsale, VABuilt 1969 · S/N 18259631 N29CMChenango 11 LLC · Wilmington, DEBuilt 1976 · S/N 18264793 N29FCUsda Forest Service Fepp · Raleigh, NCBuilt 1968 · S/N U206-1191 N29FLTorres Chris · Princeton, CABuilt 1968 · S/N 18258813 N29JFJkg LLC · Murfreesboro, TNBuilt 1968 · S/N 18259450 N29KMDebonair Consulting Inc · Wilmington, DEBuilt 1955 · S/N 31579 N29PCFisher Douglas C · Mountain View, CABuilt 1979 · S/N 18266929 N29PMAlly Mohamed Yacoob · Fort Lauderdale, FLS/N U20605769 N2AJBlair Aviation LLC · Swamp Branch, KYFirst renewal noticeBuilt 1981 · S/N R18201789 N2CNCassel Paul E · Hernando, MSS/N 18052848 N2DMWiley Post LLC · Lewes, DEBuilt 1970 · S/N 21059305 N2EBCampbell Bernard D · Morehouse, MOBuilt 1971 · S/N 18260609 N2GHAbel Robert G · Williamstown, MABuilt 1963 · S/N 2050369 N2HUN2hu LLC · Parker, COS/N R18200447 N2JKGoldberg Leonard J · Westbrook, CTBuilt 1977 · S/N 18265546 N2KDElliott Frank F · Mojave, CAFirst renewal noticeBuilt 1969 · S/N T210-0436 N2SLLowe Aviation LLC · Bountiful, UTBuilt 1977 · S/N 21061908 N2WFMaine Dept Of Agriculture Conservation & Forestry · Old Town, MEBuilt 1975 · S/N U20602849 N2XNDudebuddy Aviation LLC · Kalispell, MTBuilt 1980 · S/N 18267615 N2YROverland Missions Inc · Cocoa, FLS/N U20601737 N2ZDMelin Lynn Glenn · Scottsdale, AZBuilt 1974 · S/N 18262867 N3000QFlying H Enterprises · Santa Fe, NMBuilt 1967 · S/N 18258000 N3000YChesebro Ben D · Tucson, AZBuilt 1962 · S/N 18254000 N3001BLarsen James · Santa Rosa, CABuilt 1952 · S/N 7884 N3002QJaeger Christopher E · Normandy Park, WABuilt 1967 · S/N 18258002 N3002YGiefer Brett T · Nicollet, MNBuilt 1962 · S/N 18254002 N30038Stockyard LLC · Wilmington, DEBuilt 1973 · S/N 21059879 N3003FHassinger Farms LLC · Cove, ORBuilt 1966 · S/N 18257103

Back to AD 84-10-01 R1