Registered aircraft · 81,733

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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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.

N41594Butler John P · Hazelhurst, WIBuilt 1994 · S/N 1809113 N41598Fox Flying Club Inc · Wheaton, ILBuilt 1999 · S/N 2843290 N41599Tiger Helicopters LLC · Baton Rouge, LABuilt 1999 · S/N 4636187 N4159AHauser Associates Inc · Coral Gables, FLBuilt 1994 · S/N 1809106 N4159DBachman Aviation LLC · Independence, IAS/N 1809110 N4159KRegistered aircraftBuilt 1998 · S/N 22015C N4159MShapnek Lawrence R · Cedar Crest, NMBuilt 1947 · S/N 12-3058 N4159PSparks Brian E · Monmouth, ORBuilt 1959 · S/N 23-1644 N4159SCrew Marshall D · Spokane, WABuilt 1994 · S/N 1809109 N4159XHagglund Carl D · Pendleton, ORS/N 341 N4159YBauer Aviation LLC · Reese, MIBuilt 1977 · S/N 23877 N415AMUtah State University · Logan, UTBuilt 2005 · S/N 40.517 N415BDWhiting Ian W · Coto De Caza, CABuilt 1974 · S/N BH120/246 N415BHCentral Airlines Inc · Overland Park, KSBuilt 1960 · S/N 500B-918-5 N415CAFly For Fun Aircraft LLC · Baltimore, MDS/N 2843215 N415CCCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1968 · S/N 27-3908 N415CFAlo Fliteline Lc · Waterloo, IABuilt 1975 · S/N 28-7505118 N415ECCreativity Before Capital LLC · Tampa, FLBuilt 2006 · S/N 40415 N415GKCentral Clinton County Flying Club Inc · Jersey Shore, PABuilt 1982 · S/N 28-8290151 N415GSKirkman Robert Nolan · Pilot Mountain, NCBuilt 2004 · S/N 81406 N415HPRichmond George H Jr · Elkhorn, NEBuilt 1963 · S/N 30-181 N415JBBrewer Allen E · Madison, MSBuilt 1999 · S/N 1463 N415JSCarey James A · St Charles, ILBuilt 2016 · S/N 40874 N415KGSky Safety Inc · San Antonio, TXBuilt 2005 · S/N 40.483 N415LLost Pines Tours LLC · Bastrop, TXBuilt 1977 · S/N 32-7740073 N415LEStadelman Edwin F · East Falmouth, MABuilt 1999 · S/N 20608042 N415MEngelien Wendell · Port Orange, FLBuilt 2025 · S/N 24456 N415MDHammychan Industries LLC · Glendale, AZBuilt 1967 · S/N 27-3492 N415MRKropp Matthew M · North Creek, NYBuilt 2014 · S/N 001 N415MSNextgen Flight Academy Inc · Riverside, CABuilt 1978 · S/N 28-7816430 N415PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 2843448 N415RGalyon Aviation LLC · Sweetwater, TNBuilt 1958 · S/N TD-161 N415RCAvco Patrol LLC · Lyndon, KSBuilt 1998 · S/N 18280302 N415RJAviation Training LLC · Wilmington, DEBuilt 2005 · S/N 172S9943 N415SGriffing Flying Service Inc · Port Clinton, OHBuilt 1978 · S/N 28-7990041 N415WHPaavola Troy E · Kansas City, MOS/N 28R-7435199 N41604Schuur Rodney E · Slayton, MNBuilt 1974 · S/N 28-7415290 N41606My Flight LLC · Cypress, TXS/N 287415291 N41609Worthington John F II · Russiaville, INBuilt 1974 · S/N 28-7405124 N4160CNewman Holdings LLC · Dallas, TXBuilt 1978 · S/N R18200332 N4160FYatin Servet · Weston, MABuilt 2000 · S/N 2844028 N4160JIvy James E · Alba, TXS/N 28-22489 N4160POgle Richard W Jr · Joplin, MOS/N 23-1645 N41614Cartier Edward J Jr · Columbia, MSS/N 28-7415294 N41618Evv Warrior LLC · Evansville, INBuilt 1974 · S/N 28-7415295 N41619Charles City Aeronautics Inc · Charles City, IABuilt 1974 · S/N 28-7415296 N4161JRegistration Pending · Hardinsburg, KYRegistration pendingBuilt 1966 · S/N 28-22490 N4161PRegistered aircraftBuilt 1999 · S/N 2843309 N4161ZAri Ben Aviator Inc · Fort Pierce, FLBuilt 1998 · S/N 2843129 N41622Stingray LLC · Kalispell, MTBuilt 1974 · S/N 28-7415297

Back to AD 81-18-04 R2