Skip to content

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.

N200RLAlpha Aviation Services LLC · Chelsea, ALBuilt 1969 · S/N 28R-35210 N200STk Aviation LLC · Willow Street, PAS/N 609 N200SFRes Solutions Inc · Anderson, INBuilt 1978 · S/N 32R-7985034 N200SMMacinnis Stephen C · Richmond, TXBuilt 2001 · S/N 24557 N200SVRxy LLC · Gilbert, AZBuilt 2009 · S/N 3079 N200SXAllen Investments Aviation & Marine Inc · Fort Myers, FLBuilt 1994 · S/N 100 N200TBS&U Property Investments LLC · Wellington, FLBuilt 2023 · S/N 200TB N200TFDavis Timothy R · Nipomo, CAS/N 67 N200UHAlba Leasing Services LLC · Scottsdale, AZBuilt 2014 · S/N 4634 N200USFly More LLC · Chattanooga, TNBuilt 1976 · S/N 28-7690273 N200WAYoedhana Christian · Pflugerville, TXBuilt 1973 · S/N 28R-7335363 N200WCSigman Paul L · Incline Village, NVBuilt 1993 · S/N 792 N200WSSierra Juliet Nm LLC · Santa Teresa, NMBuilt 1974 · S/N 34-7450117 N200YRSloan Cooper · Seattle, WAS/N 28-7615279 N200ZALawrence James D · Woodbridge, VABuilt 1995 · S/N 20-0003 N200ZCTc Holdings Delaware Inc · Overland Park, KSBuilt 2020 · S/N 1187-2020 N200ZFPhillips Robert A · Saluda, NCS/N 24604 N20102Wings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 17261010 N20106Atlanta Air Academy LLC · Kennessaw, GABuilt 1972 · S/N 17261014 N2010AMaine Instrument Flight · Augusta, MEBuilt 1978 · S/N M-2066 N2010CLegner Leasing LLC · Las Vegas, NVBuilt 1958 · S/N TD-177 N2010LTec Consulting LLC · Farmingdale, MEBuilt 1978 · S/N M-2058 N2010QShadow Blade Technologies LLC · Palm Bay, FLBuilt 1973 · S/N 177RG0410 N2010TGustafson Keith W · Waleska, GABuilt 1970 · S/N 10 N2010ZSanchez Michael G · Hesperia, CABuilt 1967 · S/N 28-22409 N20115Alpha Zulu Aviation LLC · San Diego, CABuilt 1972 · S/N 17261021 N20116Paxton Roger D · Norman, NCFirst renewal noticeS/N 17702630 N2011CTuorila Leo Eric · Anderson, SCBuilt 1958 · S/N TD-178 N2011QManzo Mario A · Sacramento, CAS/N 177RG0411 N20120Bennett Robert J Jr · Minneapolis, MNBuilt 1978 · S/N M-2071 N20121Fly Maui LLC · Puunene, HIBuilt 1972 · S/N 17261025 N20123Irungu Gitau · Charlotte, NCBuilt 1972 · S/N 17261027 N20124Cerven Bohuslav Bo · Claremont, CABuilt 1977 · S/N 17702631 N20125New Horizon Aviation Inc · Warwick, RIBuilt 1978 · S/N ME-94 N20126Papa Whiskey Enterprises LLC · Merrimack, NHBuilt 2001 · S/N 18280951 N20127Lewallen David H · Alexander, ARBuilt 1977 · S/N 17702633 N2012ATownsend Brooks P · Hattiesburg, MSBuilt 1978 · S/N MC-599 N2012EAirgo Inc · Centralia, ILBuilt 1978 · S/N 17271117 N2012FEpic Aviation Inc · Denison, TXBuilt 2025 · S/N 172S13452 N2012KMaine Instrument Flight · Augusta, MEBuilt 1978 · S/N MB-901 N2012LRegistration Pending · Dallas, TXRegistration pendingBuilt 1966 · S/N 345 N2012NAirhawks Flying Clup · Eastsound, WABuilt 1978 · S/N M-2068 N2012QOwens Joseph L · Fort Mohave, AZBuilt 1973 · S/N 177RG0412 N2012YLake Robert P · Fruita, COBuilt 2006 · S/N 18281770 N20132J & L Aviation LLC · Malta, NYBuilt 1972 · S/N 17261035 N20133Creative Strategies Inc · Proctorville, OHBuilt 1972 · S/N 17261036 N20136Crate Inc · Humboldt, NEBuilt 1972 · S/N 17261038 N2013AMusketeer LLC · Fayette, ALBuilt 1978 · S/N MB-902 N2013NSimply Living LLC · Fort Myers, FLBuilt 1978 · S/N M-2070 N2013WEpic Aviation Inc · Denison, TXBuilt 2025 · S/N 172S13451

Back to AD 81-18-04 R2