Registered aircraft · 81,720

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.

N224APCloud Catcher Aviation LLC · Great Falls, MTBuilt 1977 · S/N 293/24-05 N224AZHeard Jesse H · Lewiston, IDBuilt 2021 · S/N SC-224-9821 N224BBHarris Sydnie Nicole Trustee · Austin, TXBuilt 1969 · S/N 28-25659 N224BSHoff Brian D · Spearfish, SDFirst renewal noticeBuilt 2004 · S/N 40.428 N224CBStranberg Jonathan · White Heath, ILBuilt 1996 · S/N 22450 N224CMDerstine Ernest B · Pantego, NCBuilt 1962 · S/N 2203 N224ECSweeney Edward C Jr · Parrish, FLBuilt 2017 · S/N 41792 N224ELNrcme Training Systems LLC · Breese, ILBuilt 1977 · S/N 28-7716238 N224FLFingerlakes Wing And Rotor LLC · Seneca Falls, NYS/N 1511 N224FNRush Wayne A · Troy, KSS/N CM-1 N224GAThibodeaux Jason F · Mandeville, LABuilt 2006 · S/N 22444 N224GKMontana Bizjets LLC · Missoula, MTBuilt 2015 · S/N 3257 N224GNTavares Jones Timothy E · Bridgeville, DEBuilt 2003 · S/N 049 N224HGHigher Ground Helicopters Of Cincinnati LLC · Miamisburg, OHBuilt 1991 · S/N 1719 N224HSHenderson State University · Arkadelphia, ARBuilt 2007 · S/N 2844131 N224JAWingsleasing LLC · Wichita, KSBuilt 1986 · S/N 17276588 N224JBDutchman Leasing Services LLC · Richardson, TXBuilt 1975 · S/N 28-7505140 N224JHHagg Jeffrey D · Indianapolis, INBuilt 1987 · S/N 89H29 N224KJam Three LLC · St George, UTBuilt 1959 · S/N 24-1609 N224KKN224kk LLC · Newport Beach, CABuilt 2016 · S/N 1168-2016 N224LJJets To Helis LLC DBA · Chandler, AZBuilt 2022 · S/N 4872 N224MEdwards Robert N · Topsfield, MABuilt 1991 · S/N 1 N224MAAir Future Airways Corp · Miami, FLBuilt 2000 · S/N 172S8613 N224MBBarker Ballard M · Satellite Beach, FLBuilt 1976 · S/N 177RG0935 N224MGBuell Travis · Harper, TXBuilt 2001 · S/N 3276 N224MMYoung David A · Bedford, TXBuilt 1972 · S/N 28-7225291 N224NDGood Flight Aviation LLC · Stockton, CABuilt 2001 · S/N 2842112 N224PLKeeney Charles E · Ash Grove, MOBuilt 2010 · S/N 73209 N224RVSchilthelm John A · Lake Geneva, WIBuilt 1999 · S/N 1779 N224RXFlyteone Production & Maintenance LLC · Clearwater, FLBuilt 2017 · S/N SFG014 N224SMMueller Terry L · Thomson, GABuilt 2000 · S/N 001 N224SSQuesnel Joseph P · Middlebury, VTS/N AA1A-0433 N224TVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1953 · S/N 18-2338 N224TBHot Wings Aviation LLC · Indianapolis, INBuilt 2023 · S/N 28020126 N224TNPoe Edgar A · Chandler, AZBuilt 2007 · S/N 60301 N224TPSale Reported · Carson City, NVSale reported, pending cancellationBuilt 1955 · S/N 22-2950 N224TRRasmuson Ronald F · Clancy, MTBuilt 2008 · S/N 25335 N224UKNapier Timothy N · Townsend, TNBuilt 1992 · S/N 2213 N224VUp And Up Aviation LLC · Magnolia, TXS/N 28-7916402 N224VRConcho Aviation LLC · Sterling City, TXBuilt 2000 · S/N 3038 N224VSM&G Aircraft Management LLC · Englewood, COBuilt 2022 · S/N 172S12893 N224VWMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881533 N224WWKlondike International LLC · Lewes, DEBuilt 2019 · S/N JA527-08-18 N224WYArj Extra LLC · Pinedale, WYBuilt 2014 · S/N 3224 N224XPNichols Michael H · Thompson Falls, MTBuilt 2012 · S/N 6-8554 N225George Thomas Nemeth · Hilliard, OHBuilt 2012 · S/N 803 N2250ASteele Matthew L · Saint Croix Falls, WIBuilt 1952 · S/N 22-652 N2250BBill Frank J · Enfield, CTBuilt 1978 · S/N 28-7916122 N2250EDover Afb Aero Club · Dover Afb, DEBuilt 1978 · S/N 17271205 N2250KKaemmerling Mirna C · White Oak, TXBuilt 1978 · S/N 28-7990240

Back to AD 81-18-04 R2