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.

N4588XMaus Steven M · New Braunfels, TXBuilt 1975 · S/N 28-7615036 N4588ZEta Of Missouri Inc · Lone Jack, MOBuilt 1961 · S/N 22-8097 N4589JArthurs Nathanael L · Indiana, PABuilt 1968 · S/N 28R-30462 N4589WBort Productions Inc · Covina, CABuilt 1976 · S/N 13079 N4589XSek LLC · Concordia, MOS/N 28-7690045 N458AArcher Aero LLC · Wilmington, DEBuilt 2014 · S/N 2843799 N458ARPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010058 N458BHEdwards Thomas M · New Tazewell, TNBuilt 2004 · S/N 82006 N458CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 172S13267 N458CDDiacont Charles R · Nazareth, PABuilt 2003 · S/N 18281231 N458CMUniversity Of Central Missouri · Warrensburg, MOBuilt 2000 · S/N 17280850 N458CSHarriss Robert Mallory · Mcallen, TXS/N 18282452 N458DFontelieu James · Maplewood, NJBuilt 1979 · S/N AA5B1237 N458ESB R S Leasing Inc · Wilmington, DEBuilt 1998 · S/N 18280091 N458FLGentle Mike · Pendergrass, GABuilt 1971 · S/N 28-7125254 N458KGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1995 · S/N 28-43022 N458LBBeedy Lyle G · Derby, KSBuilt 2011 · S/N 20695 N458PAFuller James Andrew · St JohnBuilt 1962 · S/N 500B-1146-80 N458RVRussell Steven J · Wilmington, ILBuilt 2006 · S/N 71458 N458SCAb Prop Plane I LLC · Metairie, LABuilt 2019 · S/N 4496490 N458SPChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 172S8323 N458UZStoik David E · Prunedale, CABuilt 1992 · S/N S-10-1-88010 N458WTls Aviation LLC · Smyrna, TNS/N 28-24511 N458WCSee Forever Holdings LLC · Wilmington, DEBuilt 2010 · S/N 18282235 N4590AEllis Darry Lynn · Wasilla, AKBuilt 1956 · S/N 18-4899 N4590BFulltron Aviation LLC · Springfield, MOBuilt 1979 · S/N 15283545 N4590FDavid Badaczewski · Gettysburg, PABuilt 1976 · S/N 28-7715052 N4590JEpic Aviation Inc · New Smyma Beach, FLBuilt 1968 · S/N 28R-30463 N4590PWings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 15284774 N4590ROzar Abdurrahman · Virginia Beach, VABuilt 1965 · S/N 28-21336 N4590TOdonald John C · Greenville, MIBuilt 1972 · S/N 28R-7235102 N4590WBfi Financial Alliances Limited LLC · Cave Creek, AZBuilt 1977 · S/N 13180 N4590ZSpeck Daniel N · Waverly, NYBuilt 1961 · S/N 22-8099 N45915Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 15282943 N4591ACollins William A · Tillar, ARBuilt 1962 · S/N 18-4901 N4591HCampbell James R · Bennett, COBuilt 1979 · S/N 24-0855 N4591RJohnson Robert B · Wichita, KSBuilt 1965 · S/N 28-21337 N4591TCherokee 235 LLC · Sidney, NEFirst renewal noticeBuilt 1972 · S/N 28-7210015 N4591WRojas Franklyn N · Ocala, FLBuilt 1976 · S/N 13081 N4591XCoral Air LLC · Rock Rapids, IAS/N 28-7610045 N4591ZColt Flying Club LLC · Lebanon, PAS/N 22-8100 N45928Cohan Thomas A · Sparks, NVBuilt 1978 · S/N 15282945 N4593ABvm LLC · Stonington, CTBuilt 1956 · S/N 18-4903 N4593FSterling Flight Training LLC · Jacksonville, FLBuilt 1976 · S/N 28-7715054 N4593VFranklin Eric J · Anchorage, AKBuilt 1980 · S/N 172RG0330 N4593XClubs 2 LLC · Calabasas, CABuilt 1975 · S/N 28-7690046 N4593YSoaring Society Of Boulder · Boulder, COBuilt 1967 · S/N 25-4278 N45941G&M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 15282952 N4594F181 Corporation · Charlotte, NCBuilt 1976 · S/N 28-7790048 N4594REkblad Carl Allyn · New Port Richey, FLBuilt 1966 · S/N 28-21341

Back to AD 81-18-04 R2