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.

N52KKVon Sternbert Nicholas Josef · Valencia, CAS/N 17700563 N52KPKrog Steven L · Hartford, WIBuilt 1995 · S/N 1994 N52KSDawson-Townsend Timothy M · Hingham, MAFirst renewal noticeBuilt 2010 · S/N 40025 N52LCHarris Bill J · Evergreen, COBuilt 1992 · S/N 539 N52LKTretter Nicholas · Holden, MABuilt 2010 · S/N 3086 N52LLSlone Corwin Scott · Waller, TXBuilt 2020 · S/N 3342 N52LULetourneau University · Longview, TXBuilt 2024 · S/N 172S13198 N52LVAltair Aircraft LLC · Gainesville, FLBuilt 1971 · S/N MC-22 N52LWN8138l LLC · Metairie, LABuilt 1999 · S/N 840-99 N52MRShealy Berry J · Augusta, GABuilt 1989 · S/N 1325 N52MSTaylor Jerry D · Blair, NEBuilt 2011 · S/N 050900074 N52PDAviation Endeavors LLC · Houston, TXBuilt 1996 · S/N 807 N52PGCrew And Mgt Svcs LLC · Union Lake, MIBuilt 1981 · S/N 6008678161247 N52PHRouth Frank D · Marion, NCBuilt 2009 · S/N 3043 N52RARennenkampf Erik J · Columbia, MDBuilt 1974 · S/N M-1626 N52RFAircraft Owners And Pilots Assoc · Frederick, MDBuilt 2024 · S/N 3440 N52RMStone Patrick S Jr · Houston, TXBuilt 1961 · S/N 1852 N52RTParks Andy J · Fort Lupton, COBuilt 1981 · S/N 078252 N52RVByars Ernest C · Mooresboro, NCBuilt 1994 · S/N 21984 N52RWWorland Flying Club LLC · Worland, WYBuilt 1973 · S/N 28-7305341 N52SLWalker John D · Neosho, MOFirst renewal noticeBuilt 2005 · S/N 2302 N52SVGreen Diamond Holdings LLC · Dallas, TXBuilt 2004 · S/N 2283 N52SWWeinstock Steven R · Schaumburg, ILBuilt 2000 · S/N 40230 N52TN52t LLC · Pleasant Prairie, WIBuilt 1971 · S/N AA1A-0212 N52TMJorgensen Aviation Inc · Richfield, UTBuilt 2019 · S/N 18283080 N52TSFox Whiskey Inc · Wilmington, DEBuilt 1946 · S/N 12-1454 N52TXSchad Thomas J · Gainesville, TXBuilt 1999 · S/N 001 N52VVLaxo Sonya · Flower Mound, TXBuilt 2003 · S/N 80718 N52WLSpeare Aviation LLC · Summerfield, NCBuilt 2014 · S/N 325-320-86 N52WWPacific Fleet Aviation LLC · Rochester, NYBuilt 1981 · S/N 27-8154014 N52XCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2017 · S/N CC19-0022 N53009Triple V Aviation LLC · Long Valley, NJBuilt 1981 · S/N 17274658 N5300HStanton David R · Washougal, WABuilt 1949 · S/N 16-111 N5300KSliviak Thomas V · Leechburg, PABuilt 1980 · S/N 17274053 N5300LUrgell Michael N · Trophy Club, TXBuilt 1968 · S/N 28-4602 N5300PMrozinski Robyn K · Hugo, MNS/N M-1628 N5300UEden Mark A · Weirsdale, FLBuilt 1964 · S/N 28-20235 N5300ZThissell David W · Plymouth, MABuilt 1961 · S/N 22-9002 N53010L & T Aviation Inc · Frederick, MDFirst renewal noticeBuilt 1981 · S/N 17274659 N53017Johnston Charles L II · Nashville, TNBuilt 1981 · S/N 17274663 N5301EMaxwell Don P II · Longview, TXBuilt 1978 · S/N 17271827 N5301HCandace A Larned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 15284083 N5301LSpagway Aviation Corp · Divide, COBuilt 1968 · S/N 28-4603 N5301TTanner Fred K · Tuscaloosa, ALBuilt 1972 · S/N 28R-7235222 N53020Iasco Flight Training Inc · Redding, CABuilt 2002 · S/N 17281136 N53023N53023 Aloha LLC · Palm City, FLBuilt 1981 · S/N 17274665 N53025Beumer Ted Anthony · Pensacola, FLBuilt 1981 · S/N 17274666 N53026Oehl Robert · Jacksonville, FLBuilt 1978 · S/N 177RG1327 N53029N53029 Cardinal LLC · Rosharon, TXBuilt 1978 · S/N 177RG1328 N5302PFarnsworth David · Evergreen, COBuilt 1958 · S/N 24-343

Back to AD 81-18-04 R2