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.

N91634Tharp Anthony W · Charleston, WVBuilt 1993 · S/N 2890178N9163DRubbert Jan Dale · Upham, NDBuilt 1958 · S/N 22-6216N9163JCavu Flight Training LLC · Freeport, MEBuilt 1966 · S/N 28-3222N9163QWebb John L · Elgin, TXBuilt 1998 · S/N 24-3422N9163WMetsker Kay B · Winnemucca, NVBuilt 1966 · S/N 28-10788N9163ZPray Aviation Inc · Augusta, KSBuilt 1989 · S/N 2841056N9164CMonmouth Aircraft Services Inc · Toms River, NJBuilt 1978 · S/N R18200433N9164JArizona Airbourne LLC · Gilbert, AZBuilt 1966 · S/N 28-3224N9164SGreat Planes Flyers LLC · Mccook, NEBuilt 1976 · S/N MC-403N9164VMccurry Larry A · Double Oak, TXBuilt 1969 · S/N 690031N9165DNelson Vanessa Jump Trustee · Portland, ORBuilt 1958 · S/N 22-6218N9165KCasey Matthey J · Sedalia, COBuilt 1989 · S/N 2890104N9165NJrh LLC · Indianapolis, INBuilt 1989 · S/N 3213020N9165SHufford Christopher · Tucson, AZBuilt 1976 · S/N M-1779N9165VJohnson Michael · Huntington Beach, CABuilt 1969 · S/N 690041N9165WPaleveda Michael · Riverview, FLBuilt 1967 · S/N 28-10790N9166EReed John A · El Centro, CAS/N 7117CN9166JRed Rock Flying School LLC · Mesa, AZBuilt 1966 · S/N 28-3226N9166LSutton Aircraft Salvage LLC · Palmer, AKBuilt 1972 · S/N 319-72N9166SHarris Douglas H · Morgan, UTBuilt 1976 · S/N M-1780N9166TBoling Scott D · Idaho Falls, IDBuilt 1979 · S/N 18-7909065N9166VSiddiqui Shariq M · Poinciana, FLBuilt 1969 · S/N 690035N91673Martin Charles W · Twain Harte, CABuilt 1973 · S/N 17261506N9167SContinental Aviation Club Inc · Lincoln, VABuilt 1976 · S/N M-1781N9167VChapman William Herbert · Dayton, OHBuilt 1969 · S/N 690015N9167WBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 28-10821N9168EAmerson Scott · Lone Oak, GABuilt 1977 · S/N 7118CN9168J2binc LLC · Adrian, MIBuilt 1966 · S/N 28-3229N9168LMoore Jon · Chuckey, TNBuilt 2003 · S/N 20812N9168QPhillipson Justin M · Vacaville, CABuilt 2001 · S/N 1167N9168VSnow James W · Avon, INS/N 690042N9169DLapaseotes George P II · Sidney, NEBuilt 1958 · S/N 22-6222N9169LSimons Grant C · White Owl, SDBuilt 1971 · S/N 320-72N9169NWestern Sky Aviation Warbird Museum Inc · St George, UTBuilt 2002 · S/N 3004N9169RDye Rodney D · Marietta, OHBuilt 2003 · S/N D0101N9169THayes George F · Friendsville, PABuilt 1979 · S/N 18-8009012N9169WPutz Michael · Mesa, AZBuilt 1966 · S/N 28-10823N916ALea Martin T · Mesa, AZBuilt 2000 · S/N 001N916ARRowe Stanley P · Pierson, FLS/N 410N916ATKdrd Holdings LLC · Texas City, TXBuilt 1982 · S/N 17275931N916AVLopez Virgilio D · Brookshire, TXS/N 17272800N916BAMaya Aircraft Holdings LLC · Lee, NHBuilt 2002 · S/N 172S9116N916BNAir Care Leasing LLC · Lamar, COBuilt 1998 · S/N 21085N916BQ9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12756N916CLDolphin Sales Inc · Wilkes Barre, PABuilt 1975 · S/N 17702273N916DBJj & Sons Aviation Services LLC · Tampa, FLS/N 438N916DPGalliot Bond LLC · Atlanta, GAS/N 27-7654183N916DROliver Randy M · Limerick, MEBuilt 1981 · S/N ROYALL-0001N916ET9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12759N916FT9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12758
Back to AD 81-18-04 R2