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.

N5645DFerenczy Vincent E · Anchorage, AKBuilt 1981 · S/N 7382CN5645FReddoch Mark W Jr · Vidor, TXBuilt 1976 · S/N 28-7790133N5645HYoder James J · Canby, ORS/N 16-256N5645LT2tc LLC · Enka, NCBuilt 1968 · S/N AA1-0045N5645PDeines E Jay · Wa Keeney, KSBuilt 1954 · S/N 24-715N5645URegistration Pending · Huntingdon, TNRegistration pendingBuilt 1969 · S/N 28-26440N56460Cessna 7870u LLC · Ottumwa, IABuilt 1973 · S/N 28-73-05596N56461Woody Aaron Michael · Cypress, TXBuilt 1973 · S/N 28R-73-35438N56462Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1982 · S/N 7409CN56463Freegard Timothy G · Phoenix, AZBuilt 1982 · S/N 7411CN5646HRiley Matthew M · White Salmon, WABuilt 1949 · S/N 16-257N5646LHutcheson Bruce D · Anthem, AZBuilt 1968 · S/N AA1-0046N5646MMaule Flight Inc · Moultrie, GAS/N 7390CN5646NTennison Gary D · Marion, TXS/N 9010CN5646QGibbons Jack Lee · Alameda, CABuilt 1981 · S/N 7386CN5646UPn4 Aviation Holdings LLC · Bishop, CAS/N 28-26442N56473Registration Pending · Fort Worth, TXRegistration pendingBuilt 1973 · S/N 287325635N56474Sampson David M · Clancy, MTBuilt 1973 · S/N 28-7425003N56475Moertl Harald A · Anchorage, AKBuilt 1982 · S/N 7423CN56477Divelbiss Donald S · Fredericktown, OHBuilt 1973 · S/N 327300063N5647LFrench Rollie T · Vermillion, SDBuilt 1981 · S/N 7370CN5647PKisken Bill D · Fairbanks, AKBuilt 1982 · S/N 7422CN5647UVargas Orlando O · San Bernardino, CABuilt 1969 · S/N 28-26443N5647WAuer David A · Springfield, ILBuilt 1962 · S/N 28-804N56487Burleson Jerry H · Grapevine, TXBuilt 1973 · S/N 28-73-25639N56488Pensacola Navy Flying Club Inc · Pensacola, FLBuilt 1973 · S/N 28R-73-35444N5648DGuhr Robert · Stockholm, NJBuilt 1982 · S/N 7418CN5648MBrown Gary R · Eagle River, AKBuilt 1982 · S/N 7415CN5648NAlbert Daniel L · New Athens, ILBuilt 1982 · S/N 7434CN5648QMartin Phil S · Colorado Springs, COBuilt 1965 · S/N 680N5648WSpinetta Lawrence J · Austin, TXBuilt 1962 · S/N 28-807N56491Registered aircraftBuilt 1982 · S/N 7399CN56496Ics Air LLC · Saint James, MNBuilt 1973 · S/N 28-7310167N5649GMaran Properties LLC · Lowell, ARBuilt 1979 · S/N 17273564N5649MChesnut Lonnie R · Palmer, AKBuilt 1981 · S/N 7395CN5649PTalarek Kai C · Far Hills, NJBuilt 1959 · S/N 24-720N5649QTaylor Clayton T · Stockton, KSBuilt 1965 · S/N 3023N5649UAzille Keran · Massapequa, NYBuilt 1969 · S/N 28-26445N5649WSmith James L Jr · Des Arc, ARBuilt 1962 · S/N 28-808N5649ZDyson Keith A · Port Townsend, WABuilt 1962 · S/N 22-9472N564ATMustang Sally Aviation LLC · Camden, SCBuilt 2005 · S/N 172S10020N564BCBravo Charlie Aviation Inc · Middletown, DENon-citizen corporation, flight hours not reportedBuilt 1984 · S/N 299N564DFPreiss Michael C · Southaven, MSS/N 269N564FLFlyguys Cessna 182 LLC · Royal Palm Beach, FLBuilt 1971 · S/N 28-7125406N564GHughes Ramzi S · Alamo, NVBuilt 1968 · S/N 15068276N564KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843880N564LMSky Horse LLC · Santa Cruz, CABuilt 2012 · S/N 20608340N564MAIndia Charlie Alpha Aviation LLC · Missoula, MTBuilt 2005 · S/N 989-2005N564MCB Air Lc · Sikeston, MOBuilt 2000 · S/N 172S8512N564MML A M Capital Management LLC · Sheridan, WYBuilt 1982 · S/N 17275714
Back to AD 81-18-04 R2