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.

N987SCJuliet Charlie Aviation LLC · Oregon City, ORBuilt 2020 · S/N 4496498N987SLBell Steven C · Lamesa, TXBuilt 2006 · S/N 1028KCMN987TReady Aim Flyer LLC · New Castle, DES/N TD-405N987TDRegistered aircraftBuilt 1974 · S/N 28R-7535075N9880GHewlett John · Columbus, OHBuilt 1971 · S/N 17259780N9880HAbell Alan R · Elgin, ILBuilt 1943 · S/N 51434N9880LTrinity Property Management LLC · Corvallis, ORBuilt 1974 · S/N AA1B-0480N9880QAircraft Resource Center Inc · Lakeville, MNBuilt 1975 · S/N 17265824N9880WJuhl Aaron · Overland Park, KSBuilt 1967 · S/N 28-23400N9880YMerrick Shane · Redgranite, WIBuilt 1961 · S/N 7GCB-73N98811Kadena Aero Club · Apo Ap, CABuilt 1985 · S/N 17276359N98819Oxford Flying Club Inc · Oxford, CTBuilt 1985 · S/N 17276362N9881GFortenberry Robert N · Pascagoula, MSBuilt 1971 · S/N 17259781N9881KHickman David R · Port Orange, FLBuilt 1977 · S/N 28-7890192N9881LFerrell D R · Stockton, CAS/N AA1B-0481N9881PSale Reported · Spartanburg, SCSale reportedBuilt 1975 · S/N 25-7556210N9881QSky Drivers LLC · Lavalette, WVFirst renewal noticeBuilt 1975 · S/N 17265825N9881UChristensen Myra J Storms · Pierre, SDBuilt 1976 · S/N AA5A0281N9881VShackleford Developments Of Sc LLC · Mount Pleasant, SCBuilt 1974 · S/N 17264544N98824Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276363N9882DUsda Aphis Ws Atoc · Cedar City, UTBuilt 1959 · S/N 18-6904N9882UNordbye Newell · Eden Prairie, MNBuilt 1976 · S/N AA5A0282N9883Whitehurst James G III · Charlotte, NCBuilt 2005 · S/N 90883N9883GLagor Mark D · Parshall, NDBuilt 1971 · S/N 17259783N9883PMinden Soaring Club Inc · Minden, NVBuilt 1975 · S/N 25-7556211N9883UPars Avn Corp · Wilmington, DEBuilt 1978 · S/N AA1C0148N98840Aviator Air Flight School LLC · Grand Prairie, TXBuilt 1998 · S/N 18280358N98843American Patrols Inc · Midland, TXBuilt 1985 · S/N 17276367N9884DMartensen Marten · Anchorage, AKS/N 18-6905N9884GBarbour John P · Dexter, MOBuilt 1971 · S/N 17259784N9884LGaston Stephen J · Saint James City, FLBuilt 1974 · S/N AA1B-0484N9884PVandegriff Cody E · Eagle River, AKBuilt 1976 · S/N 18-7709007N9884VShockley James F · Loves Park, ILBuilt 1974 · S/N 17264546N9884YRoberts Colton C · Bluebell, UTS/N 7GCB-119N98851Jacques Jerry Joseph · Iliamna, AKS/N 18-7188N98853Registered aircraftBuilt 1998 · S/N 18280316N9885DBarney Jeff S · Fairbanks, AKS/N 18-6907N9885FSky View LLC · Madison, MSBuilt 1998 · S/N 18280148N9885PTriple Cub Aviation LLC · Greenbush, MIBuilt 1976 · S/N 18-7709008N9885QAngel Aviation Inc · Peoria, AZBuilt 1975 · S/N 17265829N9885USchneider Fred M Jr · Fishkill, NYBuilt 1977 · S/N AA5A0285N9885VNix Jacob DBA · Johnson, KSBuilt 1974 · S/N 17264547N9885YCentral Air Parts Inc · Staunton, ILS/N 145N9886CAlm Ronald · Kuna, IDBuilt 1978 · S/N R18200482N9886KSmart03 LLC · Kissimmee, FLBuilt 1977 · S/N 28-7816205N9886NHall Benton G · Plano, TXBuilt 1994 · S/N 2230N9886VBognar John W III · Sardinia, NYBuilt 1974 · S/N 17264548N9886WLathem Emma K · Amarillo, TXS/N 28-23406N98873Laguna Verde Leasing Inc · Wilmington, DEFirst renewal noticeBuilt 1985 · S/N 17276369N98875Breun David J · Albuquerque, NMS/N 19135
Back to AD 81-18-04 R2