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.

N733AQCrankshaft Aviation LLC · Pine River, MNBuilt 1976 · S/N 17268147N733ATAlpha Tango LLC · Lake Village, ARBuilt 1976 · S/N 17268150N733AVPdm Aviation LLC · Greencastle, INBuilt 1976 · S/N 17268152N733AWKaiser Eric J · Milford, INBuilt 1976 · S/N 17268153N733AYFord Eagles Inc · Plymouth, MIBuilt 1976 · S/N 17268155N733AZTactical Integrated Training Solutions LLC · San Antonio, TXBuilt 1976 · S/N 17268156N733BCPs N733bc LLC · Green Bay, WIBuilt 1976 · S/N 17268159N733BDRegistered aircraftBuilt 1976 · S/N 17268160N733BEFlying Particles Inc · Livermore, CABuilt 1976 · S/N 17268161N733BGAviator Air Flight School LLC · Grand Prairie, TXBuilt 1976 · S/N 17268163N733BKB & R Aircraft LLC · Wadsworth, OHBuilt 1976 · S/N 17268166N733BPDavis Keith I · Manchester, TNS/N 17268170N733BRAmalong Tim M · Tucson, AZBuilt 1976 · S/N 17268172N733BSJulius William C · Julesburg, COS/N 17268173N733BTNorthern Air Aviation LLC · Naples, IDBuilt 1976 · S/N 17268174N733BZBz Partners Inc · Purcellville, VABuilt 1977 · S/N 17268180N733CASlowinski David · Chippewa Falls, WIBuilt 1976 · S/N 17268181N733CBDavis Lisa E · Tucson, AZBuilt 1976 · S/N 17268182N733CCFabrie Terry M · Bakersfield, CABuilt 1976 · S/N 17268183N733CEN2893e LLC · Reno, NVS/N 17268190N733CMBotson William J · New Smyrna Beach, FLBuilt 1976 · S/N 17268191N733CNChristiansen Aviation LLC · Wilmington, DEBuilt 2021 · S/N 172S12733N733CPWesterly Air LLC · Westerly, RIBuilt 1976 · S/N 17268193N733CQGulf Coast Helicopters Inc · Pearland, TXBuilt 1976 · S/N 17268194N733CRNixon Kendal H · Miami, FLBuilt 1976 · S/N 17268195N733CSFly Aviation Corp · Wilmington, DEBuilt 1976 · S/N 17268196N733CUColeman Michael F · Pelham, NHBuilt 1976 · S/N 17268198N733CVBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 17268199N733CXDon Davis Aviation Inc · Henderson, KYBuilt 1976 · S/N 17268201N733CZManning And Sons Property LLC · Summerville, SCBuilt 1976 · S/N 17268203N733DGReisz Michael E · Cresson, TXBuilt 1976 · S/N 17268210N733DL523 Flying Club · Williamson, WVBuilt 1976 · S/N 17268214N733DNTraining Planes LLC · Tampa, FLBuilt 1976 · S/N 17268216N733DPNiemi Aviation LLC · Glyndon, MNBuilt 1976 · S/N 17268217N733DRMarc Aircraft Holding LLC · Soldotna, AKS/N 17270924N733DTForstner Christopher R · Hensler, NDS/N 17268221N733DXWiechmann Donald G · Wagner, SDBuilt 1976 · S/N 17268225N733DZLarson Dylan J · Perham, MNBuilt 1976 · S/N 17268226N733EAJohnson Scott A · Cohasset, MNBuilt 1976 · S/N 17268227N733EBB&R Aircraft LLC · Wadsworth, OHBuilt 1976 · S/N 17268228N733EJBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 17268235N733ELNc 86 Flying Club Inc · Mooresville, NCBuilt 1976 · S/N 17268237N733EMEricson William R · Traverse City, MIBuilt 1976 · S/N 17268238N733ENBurr Ralph M · Roanoke, VABuilt 1976 · S/N 17268239N733EPSkytec Aviation LLC · Boynton Beach, FLBuilt 1976 · S/N 17268240N733EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2024 · S/N 172S13162N733ESWings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17268243N733EVCriscolo John T · East Setauket, NYBuilt 1976 · S/N 17268246N733EWS S T & J LLC · Minden, NEBuilt 1976 · S/N 17268247N733EZBi Plane Adventures Inc · Kennesaw, GABuilt 1976 · S/N 17268250
Back to AD 81-18-04 R2