AD 81-18-04 R2

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
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.

N591PTRegistered aircraftBuilt 1977 · S/N 32R-7880026N591RVSims David L · Mc Alpin, FLBuilt 2025 · S/N 93270N591TXSchechter Andrew M · Goshen, OHBuilt 2022 · S/N 001N591VUVu Anh · Fredericksburg, VABuilt 2006 · S/N 40141-1AVN5920DBates Matthew T · Springfield, VABuilt 1956 · S/N 22-4582N5920HZakrzewski Patrick J · Waterford, WIBuilt 1949 · S/N 16-532N5920LSharratt Mark M · Ogilvie, MNBuilt 1969 · S/N AA1-0220N5920QKellogg Annabelle S · Cumming, GABuilt 1965 · S/N 825N5920WSynergy Aviation LLC · Greer, SCBuilt 1966 · S/N 28-3223N5921HHoehne Michael G · Vienna, VABuilt 1949 · S/N 16-542N5921PFiscus Ryan K · Burleson, TXBuilt 2022 · S/N 059N5921WStearns Edwin Ben Jr · Eloy, AZS/N 28-3227N5922EAerial Scouting Solutions LLC · Sioux Center, IABuilt 1978 · S/N 17271963N5922FNeel Aviation LLC · Lakeland, FLBuilt 1976 · S/N 28-7715158N5922HGifford Gary W · Lighthouse Point, FLS/N 16-544N5922LJokerst Kenneth · Saint Louis, MOBuilt 1969 · S/N AA1-0222N5922PWiseman Transport LLC · Henderson, TXBuilt 1959 · S/N 24-1009N5922UPagan Jose A · Kokomo, INBuilt 1970 · S/N 28-26408N5922ZBellamy John Mark · Freeville, NYBuilt 1964 · S/N 22-9791N5923LKane Christopher M · Sacred Heart, MNS/N 7GC-80N5923WPremier Pilots LLC · Herriman, UTBuilt 1966 · S/N 28-3246N5924FN5924f LLC · Cocoa, FLS/N 28-7715159N5924PPope Mark I · Arco, IDBuilt 1959 · S/N 24-1011N5924QWright Andrew · Sacramento, CABuilt 1965 · S/N 827N5924UOrganization Of Black Aerospace Professionals Inc · Westchester, ILBuilt 1970 · S/N 28-26815N5924WPribbenow Dennis A · Payson, AZBuilt 1966 · S/N 28-3273N59262Tabbert William Stanley · Diamondhead, MSS/N F-2N5926BAddington Ralph P · Orlando, FLS/N 90712N5926DToste Greg · Newcastle, CABuilt 1956 · S/N 22-4589N5926FRegistered aircraftBuilt 1976 · S/N 28-7790143N5926UIron Flyer Of Cuzamil LLC · Lewes, DES/N 28-26739N5926WLeonard Jeffrey A · Bakersfield, CABuilt 1966 · S/N 28-3311N5927HParley Michael D · Carmel, CABuilt 1949 · S/N 16-549N5927LTri State Airmotive LLC · Berryville, ARBuilt 1969 · S/N AA1-0227N5927PSchlup John R · Booneville, ARBuilt 1959 · S/N 24-1015N5927WKochling Christopher · Houston, TXBuilt 1966 · S/N 28-3331N5928EGace Flying Club Inc · Ronkonkoma, NYBuilt 1978 · S/N 17271964N5928JParsons Royson A · Atascadero, CABuilt 1971 · S/N A1500228N5928QSchmidt Tyren A · Albertville, MNBuilt 1965 · S/N 829N5928WRegistered aircraftN-number assigned, not yet registeredS/N 28-3367N5929TFlight School Of Gwinnett Inc · Lawrenceville, GABuilt 2002 · S/N 17281105N5929WEdwards Allan · Leesburg, VABuilt 1966 · S/N 28-3368N5929ZBrown Dave M · Crescent City, CABuilt 2013 · S/N 75-8517N592CJAims Community College · Greeley, COBuilt 2019 · S/N 2881183N592CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 172S12731N592DJFandango Ranch Operating Co Inc · Anacortes, WAS/N 592N592FLGrey Rose Air LLC · Edenton, NCBuilt 1971 · S/N 28-7125455N592JSStraut James M · Upper Saddle River, NJS/N 18281041N592KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843931N592MBIngle Allen B · Goldsboro, NCBuilt 2012 · S/N 83078
Back to AD 81-18-04 R2