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.

N9291FHealey David A · Hammondsport, NYBuilt 1975 · S/N 850428N9291HDawson William F Jr · Port Hueneme, CABuilt 1975 · S/N 17266071N9291JMidwest Aero Club Inc · Omaha, NEBuilt 1966 · S/N 28-3377N9291KNeff Brandon L · Emporia, KSBuilt 2005 · S/N 60433N9291RBobo Richard H · Okolona, MSBuilt 1978 · S/N R18200680N9291VHutchens David R · Pikeville, KYS/N 690082N9291WFarleman LLC · Aurora, OHBuilt 1968 · S/N 28-11100N9292HBlackhawk Flying Club Inc · Rockford, ILBuilt 1975 · S/N 17266072N9292LRegistered aircraftBuilt 1997 · S/N 3246092N9292MAkro N9292m LLC · Lighthouse Point, FLBuilt 1966 · S/N 1225N9292QRegistered aircraftBuilt 1997 · S/N 3246077N9292ZAbrams Perry · Palmer, AKS/N 186971N92934Service Oriented Aviation Readiness (Soar) · Bolivar, MOBuilt 1973 · S/N 17261650N9293BCludy Skies LLC · Wildwood, MOBuilt 1997 · S/N 2843100N9293JChaldu Ronald S · Oswego, NYBuilt 1966 · S/N 28-3381N9293KYakel Donald L Jr · Springfield, ILFirst renewal noticeBuilt 1997 · S/N 3246093N92945Fla Inc · Wilmington, DEBuilt 1973 · S/N 17261655N92949Prouts Travel LLC · Wilmington, DES/N 3246094N9294BHall Justin E · York, NEBuilt 1958 · S/N 55094N9294NCmhw LLC · Memphis, TNBuilt 1998 · S/N 3246104N9294QPlane Training LLC · Rapid City, SDBuilt 1998 · S/N 2843122N9294VMulligan Sean S · Kitty Hawk, NCBuilt 1969 · S/N 690082N9294WBorkowski Brian L · Irwin, IABuilt 1967 · S/N 28-10971N9295DStanford Jay H · Anchorage, AKS/N 18-6602N9295HMiami Seaplane Tours Inc · Miami, FLBuilt 1975 · S/N 17266075N9295SSteadman John Harold · Santa Clarita, CABuilt 1975 · S/N M-1630N9295VSt Denis Robert G · Lake City, FLBuilt 1969 · S/N 690084N9295WH&H Aircraft LLC · Scottsbluff, NEBuilt 1967 · S/N 28-10972N9296HSmith Richard A · Burnsville, MNBuilt 1975 · S/N 17266076N9296JAlpha Kilo Aviation LLC · Wasilla, AKBuilt 1966 · S/N 28-3386N9296LTrites Henry E · Granville, OHBuilt 1971 · S/N AA1A-0196N9296SShindel Mark · Los Gatos, CABuilt 1975 · S/N MC-334N9296VOswald Paul C · Shohola, PABuilt 1970 · S/N 700049N92970Elizabeth City State University · Elizabeth City, NCBuilt 2011 · S/N 172S11124N9297C831 Aviation LLC · Salinas, CABuilt 1978 · S/N 32-7840093N9297MBowers Matthew Monroe · Dayton, NVBuilt 1966 · S/N 1230N9297SNovak David J · Hortonville, WIBuilt 1996 · S/N 037N9297WTorrey Robert E · Pleasant Hill, CABuilt 1967 · S/N 28-10974N9297YHart Linda B · San Antonio, TXBuilt 1977 · S/N AA5B0547N9298JSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1997 · S/N 2843107N9298LLangenberg Stewart M · Santa Barbara, CABuilt 1998 · S/N 3246108N9298PBlackhawk Airventures LLC · Wilmington, DEBuilt 1997 · S/N 3246088N9298SQuality Aviation Inc · Atlanta, GABuilt 1975 · S/N M-1629N9298VJones Eric S · Tucson, AZBuilt 1969 · S/N 690067N9298WUniversal Avn Inc · La Cygne, KSBuilt 1967 · S/N 28-10975N9298ZFrederick Ag LLC · Humboldt, KSS/N 17701215N92995Yoanna Flight School Inc · Fort Myers, FLBuilt 1981 · S/N 15285372N9299BBird Acquisition LLC · Phoenix, AZBuilt 1998 · S/N 2843116N9299JLucas Steven R · Canton, OHBuilt 1966 · S/N 28-3389N9299LKing Angela · Raleigh, NCBuilt 1971 · S/N AA1A-0199
Back to AD 81-18-04 R2