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.

N733VLYuma Ag Service Inc · Yuma, COBuilt 1977 · S/N 17268582N733VRLegends Air Center LLC · Bentonville, ARBuilt 1977 · S/N 17268587N733VSClemson Flying Club Inc · Seneca, SCBuilt 1977 · S/N 17268588N733WCDrouin Roger R · Naples, FLBuilt 1977 · S/N 17268598N733WEAirwaves Nsb LLC · New Smyrna Beach, FLBuilt 1977 · S/N 17268600N733WGMiloud Chad · Fort Worth, TXBuilt 1977 · S/N 17268602N733WHFritts Paul D · Southworth, WABuilt 1977 · S/N 17268603N733WLShadduck James N · Annandale, MNS/N 17268606N733WMNakamura Hajime Trustee · Long Beach, CABuilt 1977 · S/N 17268607N733WSAirgo Inc · Centralia, ILBuilt 1977 · S/N 17268612N733WTAnderson Aviation Services Inc · Carlsbad, CABuilt 1977 · S/N 17268613N733WUAviator Air Flight School LLC · Grand Prairie, TXBuilt 1977 · S/N 17268614N733WVRatzlaff Jeff DBA · Langdon, NDBuilt 1977 · S/N 17268615N733WWFm Aviation Inc · Concord, CABuilt 1977 · S/N 17268616N733WXSpartan Marine Co · Capistrano Beach, CAS/N 17268617N733WYFlys And Floats C172 LLC · Panama City Beach, FLS/N 17268618N733XMiddleton Mary David · Austin, TXBuilt 1967 · S/N 680045N733XBBlair Burkholder Inc · Erie, COBuilt 1977 · S/N 17268621N733XEAeroventures Flying Club Inc · Lilburn, GABuilt 1978 · S/N 17268624N733XFBeaugez Gregory C · Perkinston, MSBuilt 1977 · S/N 17268625N733XKSabol Edward J Trustee · Leominster, MABuilt 1977 · S/N 17268629N733XLAirspeed Marketing LLC · Phoenix, AZBuilt 1977 · S/N 17268630N733XMRoatis Calin V · Sacramento, CAS/N 17268631N733XNFlyn Go LLC · Spring, TXBuilt 1977 · S/N 17268632N733XZ3650 Aircraft Inc · Bakersfield, CABuilt 1977 · S/N 17268643N733YBZulu Aerospace Services LLC · Peoria, AZBuilt 1977 · S/N 17268645N733YEDiederich Fred H · Fayette City, PABuilt 1977 · S/N 17268648N733YGLeaschauer Eitan · San Jose, CABuilt 1977 · S/N 17268650N733YHBailey Gordon J · Fayetteville, GABuilt 1977 · S/N 17268651N733YPMiller Robert · Battle Creek, MIBuilt 1977 · S/N 17268657N733YRBoccaccio Donald O · Hypoluxo, FLBuilt 1977 · S/N 17268659N733YTRegistration Pending · Centereach, NYRegistration pendingBuilt 1977 · S/N 17268661N733YYTetrault Howard D · Malabar, FLBuilt 1977 · S/N 17268666N733YZSeaplane Adventures LLC · Cheyenne, WYBuilt 1977 · S/N 17268667N733ZBMidstate Aviation 1 LLC · Owosso, MIBuilt 1977 · S/N 17268669N733ZEKgr Aviation LLC · Austin, TXBuilt 1977 · S/N 17268672N733ZKStone Aviation LLC · Sacramento, CABuilt 1977 · S/N 17268677N733ZNAtmospheric Vehicle & Spacecraft Flt Exploration · Rch Palos Vrd, CABuilt 1977 · S/N 17268680N733ZPFruit Belt Flyers Inc · Saint Joseph, MIBuilt 1977 · S/N 17268681N733ZSMccown Jamey · Bayfield, COBuilt 1977 · S/N 17268684N733ZYHess Garrett J · Fullerton, CAS/N 17268690N733ZZDuncan James · La Porte, TXBuilt 1977 · S/N 17268691N734United States Department Of Agriculture · Cedar City, UTBuilt 1956 · S/N 18-5258N73401Sage Kathlene A · Bass River, MABuilt 1976 · S/N 17267431N73407Wxly Aviat LLC · Gastonia, NCBuilt 1976 · S/N 17267435N7340BThaut Lance A · Fullerton, CABuilt 1977 · S/N A1520752N7340LAzure 01 LLC · Canton, NYBuilt 1978 · S/N A1520792N7340PWard James A · Brentwood, TNBuilt 1961 · S/N 24-2519N7340WMillar Russell J · Saint Onge, SDS/N 28-1211N7340YStark Stephen · Fort Lauderdale, FLBuilt 1977 · S/N R18200118
Back to AD 81-18-04 R2