OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,720

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.

N20CTN20ctid LLC · Pocatello, IDBuilt 1978 · S/N 152-81952N20CUCosta Flying Service Inc · Painted Post, NYBuilt 1980 · S/N 172RG0323N20DKFlight Surgeon LLC · Fayetteville, ARBuilt 1976 · S/N 17266836N20DUWings Of Hope · Chesterfield, MOBuilt 1985 · S/N 529N20DVSharp Robert M Trustee · Jenks, OKBuilt 2016 · S/N CC18-0081N20DXBig Sur USA LLC · Boca Raton, FLS/N 613N20DYBpw Aviation LLC · Huntsville, ALS/N 614N20DZWeathers Air LLC · Longwood, FLBuilt 1986 · S/N 615N20EA4-D Aviation Consulting LLC · Wilmington, DEBuilt 2001 · S/N 007N20EHUnzicker Keith R · Benson, ILBuilt 1966 · S/N 1090N20ELJrhav LLC · Chassell, MIS/N 622N20EMReifert Todd · Louisville, KYBuilt 1981 · S/N 0001N20EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2020 · S/N 172S12513N20ETClear Skies Avionics Inc · Clearwater, FLS/N 621N20EUWerking John William III · New Windsor, MDS/N 628N20FLowden Howard J · Rome, GABuilt 1965 · S/N TD-623N20FKJohnston Brian · Bethany Beach, DES/N 637N20FSDahm Douglas W · Discovery Bay, CAS/N 23122N20FVRogers Robert D Jr · Keller, TXBuilt 1986 · S/N 642N20GGHofer Danny C · Huron, SDBuilt 1978 · S/N 28-7916032N20GKHashmi Aijaz · Riverside, CAS/N 646N20GUBaldree Christian Blair · Roseville, CAS/N 655N20GWWyatt John B · Culpeper, VABuilt 1977 · S/N 1N20HTRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1969 · S/N 17258306N20HURussell Michael E · Sumner, TXBuilt 2025 · S/N 3455N20HYTack John A · Wasilla, AKBuilt 1998 · S/N 2001N20JBBastian Richard L · Burns, WYBuilt 1974 · S/N 1-0031N20JCJcmc Inc · Junction City, KSBuilt 1955 · S/N 22-2879N20JDDesroches John · Scottsdale, AZBuilt 1962 · S/N 28-375N20JEReid Keith D · Vinemont, ALBuilt 1996 · S/N 20N20JMWaeltz Mark A · Lantana, FLBuilt 1967 · S/N 28-4393N20JPJohnson Leif M · Midlothian, TXBuilt 1993 · S/N 783N20JVVan Antwerp John · Sebastian, FLBuilt 2016 · S/N JVX201N20JZWest William D · Newton, NCBuilt 1986 · S/N 652N20KBAnderson David R · Sycamore, ILBuilt 1976 · S/N M-2-570N20KGAdspitalny LLC · Waynesville, MOBuilt 1986 · S/N 668N20KHN20kh LLC · Clewiston, FLBuilt 2021 · S/N 18283153N20KJOxford Flying Club Inc · Oxford, CTBuilt 1998 · S/N 18280143N20KLBuell Kenneth B · Port Orange, FLBuilt 1986 · S/N 669N20KNShaw William C · Carmel, NYS/N 682N20KPHulsey Ryan A · Cleveland, GAS/N 683N20LEQuality Leasing Inc · Niceville, FLBuilt 1994 · S/N 1809080N20LFFerguson Michael W · Burlington, WIBuilt 2020 · S/N 91029N20LGYerena Mario Cesar Gutierrez · Bethel Island, CABuilt 1968 · S/N 28R-30491N20LKHobert Robert W Trustee · Penn Valley, CABuilt 2001 · S/N 21299N20LLFlying 20 Club Inc · Springfield, ILBuilt 1978 · S/N 28-7990119N20LTSeagull Services LLC · San Rafael, CABuilt 2003 · S/N 26015CN20MNRichardson William L · Houston, TXBuilt 1999 · S/N 425N20MRRegistered aircraftBuilt 1997 · S/N 21391N20MUOracle Aviation LLC · Omaha, NEBuilt 1978 · S/N 17271496
Back to AD 81-18-04 R2