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.

N96092Florida Flyers Flight Academy Inc · Saint Augustine, FLBuilt 1985 · S/N 15286006N96096Jwa Flight School LLC · Bolingbrook, ILBuilt 1985 · S/N 15286007N9609HWilliams Marc A · Fallon, NVBuilt 1990 · S/N 1167N9609JAdams Donald J · Lock Haven, PABuilt 1966 · S/N 28-3755N9609PMerlin Aviation Inc · Moriarty, NMBuilt 1976 · S/N 25-7656007N9609QWestrup Gregory W · Greensburg, INBuilt 1975 · S/N 17265694N9609VFly Fly Fly LLC · Dover, DEBuilt 1971 · S/N 21-0015N9609WCullen Michael R · Fort Mohave, AZBuilt 1967 · S/N 28-23062N960ACNaples Air Center Inc · Naples, FLBuilt 1990 · S/N 2841325N960AUAuburn University · Auburn, ALBuilt 2017 · S/N 172S12098N960CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281990N960DGN960dg LLC · Idaho Falls, IDS/N 1330N960DSDelta State University · Cleveland, MSBuilt 2024 · S/N 322/USN960FSSouthern Aero LLC · Homestead, FLBuilt 1974 · S/N 17263386N960GSStevens Chad M · Huntsville, ALBuilt 1964 · S/N 2858N960KMMorris Ag Air And Sons Inc · Orovada, NVBuilt 2018 · S/N 81240N960MSMt San Antonio Community College District · Walnut, CABuilt 2001 · S/N 172S8859N960ROpar Lauren · Morrisville, NCBuilt 2008 · S/N 3003N960RMCag International Inc DBA · Longmont, COBuilt 2000 · S/N 852-99N960RSSouthard James E Jr · Charleston, SCBuilt 1975 · S/N AA5-0807N960RVHouse Gregory E · Sealy, TXBuilt 2001 · S/N 80006N960TAInnoutaero LLC · Stockton, CAS/N 172S8960N960TEBeauregard Timothy · Haslet, TXBuilt 2004 · S/N 10239N960VSSauder Philip J · Peninsula, OHBuilt 1959 · S/N 18-6799N960WCStardust Aviation LLC · Farmingdale, NYBuilt 2000 · S/N 2843368N96100Trajectory Aviation LLC · Hollywood, FLBuilt 1983 · S/N 17276020N96105Demon Air LLC · Palm City, FLS/N 17276023N9610BGoodman Aviation LLC · Choteau, MTBuilt 1990 · S/N 1169N9610CHageman Theron · Jay Em, WYBuilt 1991 · S/N 1171N9610DHicks Joseph O · Germanton, NCBuilt 1958 · S/N 22-6520N9610QUS Aviation Group LLC · Denton, TXBuilt 1976 · S/N 17265695N9610RReynolds Kirk S · Skaneateles, NYBuilt 1959 · S/N TD-305N9610SLake A Randy · San Diego, CABuilt 1966 · S/N 265N9610UMaschek Anthony Q · Harker Heights, TXBuilt 1975 · S/N AA5-0810N9611CSamrat Prithviraj Inc · Miami, FLBuilt 1997 · S/N 1N9611JStull Donald K · Catawba, NCBuilt 1966 · S/N 28-3761N9611MElectron Neutrino Inc · Lewes, DEBuilt 1966 · S/N 670188N9611UKingsley Paul A II · Idledale, COBuilt 1975 · S/N AA5-0811N9612DSoto Edward · Wasilla, AKBuilt 1958 · S/N 22-6522N9612HRegistration Pending · Ocean Isle Beach, NCRegistration pendingBuilt 1975 · S/N 17266263N9612JReich Gregory N · Schwenksville, PABuilt 1966 · S/N 28-3810N9612LSolomon Michael G · Dallas, GABuilt 1973 · S/N AA1B-0112N9612UElizabeth B Hawley · Wichita Falls, TXBuilt 1975 · S/N AA5-0812N9612VLe Roux Rocco · Carlsbad, CABuilt 1971 · S/N 21-0018N9612WJama Aviation LLC · Blaine, MNBuilt 1967 · S/N 28-23066N9613AHamiter Trace A · Auburn, ALBuilt 1978 · S/N 505N9613HFiedler Mark · Wichita, KSBuilt 1975 · S/N 17266264N9613JKraun Fred M · Fall City, WABuilt 1966 · S/N 28-3766N9613LPederson Patrick D · Cotati, CABuilt 1973 · S/N AA1B0113N9613MLeland Erik J · Beaverton, ORS/N 670190
Back to AD 81-18-04 R2