OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,728

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.

N2436MVenture Aviation Inc · Arlington, MABuilt 1977 · S/N 28R-7837089N2436NThunderbird Aviation · Bloomington, MNBuilt 2000 · S/N 17280842N2436VGt Holdings LLC · Nashville, TNBuilt 2006 · S/N 18281786N2436WThunderbird Aviation · Bloomington, MNFirst renewal noticeBuilt 2000 · S/N 17280841N2436YAlpha Flight Academy · Concord, CANon-citizen corporation, flight hours not reportedBuilt 1985 · S/N 28-8516056N24372Curns James R · New London, WIBuilt 1970 · S/N 28-5665N24373Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280240N24376C R Transport Inc · Wilmington, DEBuilt 2000 · S/N 18280704N2437LLean Enterprises Inc · Brookhaven, MSBuilt 2006 · S/N 18281791N2437MRock Full Gospel Church · Parkersburg, WVBuilt 1979 · S/N 27-7954058N24385Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1977 · S/N 15280248N24389Way Of The Lord LLC · London, KYBuilt 2000 · S/N 18280708N2438AHorse Creek 3518 Inc · Hollywood, FLBuilt 2006 · S/N 18281793N2438ERainier Flight Service LLC · Renton, WABuilt 2000 · S/N 17280878N2438FMackie Scott Christopher · Elkton, MDBuilt 2006 · S/N 18281794N2438LHart Lewis W · Rexburg, IDBuilt 1979 · S/N 38-79A0703N2438PDavey Kenneth E · Lake Crystal, MNBuilt 1955 · S/N 22-2809N2438RSpeed Hunter Aviation LLC · Franklin, OHBuilt 1969 · S/N 28-5622N2438SMid-Island Air Service Inc · Ronkonkoma, NYFirst renewal noticeBuilt 2000 · S/N 17280875N24397Bryant Margaret A · Tallahassee, FLBuilt 1979 · S/N 38-79A1114N24399Lcc North LLC · Freehold, NJBuilt 1977 · S/N 15280252N2439BVan Bortel Aircraft Inc · Arlington, TXBuilt 2001 · S/N 18280955N2439C206 Aircraft Leasing Co Inc · Marathon, FLBuilt 2000 · S/N 20608100N2439MRegistered aircraftBuilt 1947 · S/N 12-1667N2439PNeal Christopher C · Staples, MNBuilt 1955 · S/N 22-2810N2439TSkylane 2439t Partners LLC · Burlingame, CABuilt 2000 · S/N 18280810N2439ZPlane Nonsense Inc · Middletown, DEBuilt 2007 · S/N 172S10564N243AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881733N243AKHilwig Kara · Wasilla, AKBuilt 1989 · S/N 1809010N243ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496042N243AURunamuck LLC · New Orleans, LABuilt 2024 · S/N 172S13223N243CGTampa Bay Soaring Society · Zephyrhills, FLBuilt 1972 · S/N 25-5450N243CMRegistered aircraftS/N 545EN243CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12338N243CYHarvey Steven T · Honolulu, HIBuilt 2000 · S/N 2081N243DBMainpro Inc · Alexandria, KYBuilt 2002 · S/N 2315N243EHVeracity Aviation LLC · Seguin, TXS/N 3482N243EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2025 · S/N 172S13281N243GArcher Aero LLC · Wilmington, DEBuilt 2019 · S/N 2881113N243HAAtp Aircraft 8 LLC · Wilmington, DEBuilt 2015 · S/N 172S11583N243JAYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 28020019N243JGBateman Scott R · Montrose, CABuilt 2001 · S/N 80669N243JHFlowers Derrick W · San Antonio, TXBuilt 2016 · S/N 20454N243JWUhles Denny · Bakersfield, CABuilt 1983 · S/N 243N243KJeffryes Richard B · Creswell, ORFirst renewal noticeBuilt 1946 · S/N 7AC 2710N243MAJ W Peterson Inc · Warren, MNBuilt 2003 · S/N 479-2003N243MDWhiteis Barnabas G · Apex, NCBuilt 1997 · S/N 20665N243MEMcaleer William V Jr · Milledgeville, GABuilt 2000 · S/N 20608113N243MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881708N243RLAtp Aircraft 8 LLC · Wilmington, DEBuilt 2015 · S/N 172S11595
Back to AD 81-18-04 R2