AD 90-04-06 R1

Registered aircraft · 68,377

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:90-04-06-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
  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.

N5890VEller Patricia E · Lutz, FLBuilt 1977 · S/N 28-7790508N5891DRiggs J'Ann · Wasilla, AKBuilt 1956 · S/N 18-5318N5891HFelske Michael J · East Troy, WIBuilt 1949 · S/N 16-512N5891LAlldridge Thomas H · Cochranville, PABuilt 1972 · S/N AA5-0091N5891RTun Bay Inc · Wasilla, AKBuilt 1966 · S/N 17253560N5891U2dwh LLC · Katy, TXBuilt 1970 · S/N 28-26727N5891WMarino Mario Mennona · King Of Prussia, PABuilt 1965 · S/N 28-2633N58923Singh Jaspal · Sacramento, CABuilt 1973 · S/N 18262394N5892UFeighl Engineering Group Inc · Hot Springs, ARS/N 28-26735N5892ZCarbiener Ross · Kewanee, ILBuilt 1963 · S/N 22-9756N5893HAmos Derek L · Helena, MTBuilt 1949 · S/N 16-513N5893LHegwood Jonathan E · Petal, MSBuilt 1972 · S/N AA5-0093N5893UCasper Gary · Spring Creek, NVBuilt 1970 · S/N 28-26706N5893WFinch Howell M Jr · Victoria, TXBuilt 1965 · S/N 28-2645N5893ZKugmach LLC · Holdrege, NEBuilt 1963 · S/N 22-9758N5894LTrueblood Terry L · Effingham, ILBuilt 1972 · S/N AA5-0094N5894QBlech Fritz · Grants Pass, ORBuilt 1965 · S/N 3155N5894ZRussell Webster K · Ridgeland, MSS/N 22-9759N5895HThompson Timothy G · Kenosha, WIBuilt 1949 · S/N 16-517N5895LWatkins Marion D · Mcdonough, GABuilt 1972 · S/N AA5-0095N5895ZMerrick Richard W · Bernville, PABuilt 1963 · S/N 22-9761N5896UGift Academy Inc · Vernon, TXS/N 28-26792N58975Anderson Kirk M · Prosser, WABuilt 1944 · S/N 75-5792N5897LCulver Christopher J · Rockmart, GABuilt 1972 · S/N AA5-0097N5897QBarsi Jeffrey D · Bonham, TXBuilt 1965 · S/N 813N5898LLamer Benjamin W · Ada, MIBuilt 1972 · S/N AA5-0098N5898QO'Neal Timothy L · Damascus, ORBuilt 1965 · S/N 3157N5898VMaxair Inc · Coxs Creek, KYBuilt 1977 · S/N 28-7716213N5898WFrazier Justyn K · Mesa, AZS/N 28-2708N589APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843765N589CBBryan Curtis · Enumclaw, WAS/N 589N589LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2023 · S/N 28020107N589RAMcgowin James E · Ball Ground, GABuilt 2007 · S/N 60589N589RPEdmundson George · Hood River, ORS/N 5589N589SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881407N589SPHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2000 · S/N 172S8519N589TFam Vans Inc · Fountain Valley, CAS/N 40.503N589TRRussell Tony B Jr · Severance, COBuilt 1975 · S/N 589N58AEKraujales Adam M · East Moriches, NYS/N 28-5075N58ATTurner Michael A · Cartersville, GABuilt 1994 · S/N 1266N58BWarnick Ronald S · Cascade, MTBuilt 1968 · S/N 15068409N58BABank Of Utah Trustee · Salt Lake City, UTBuilt 1957 · S/N 969N58BFH Jack Flash Inc · Fort Worth, TXS/N 12013N58BGStassi Jean-Paul A Jr · Henagar, ALS/N 312N58BHPierson Ted · Gooding, IDBuilt 2015 · S/N 568-2015N58CTS 1t LLC · Parkland, FLS/N 1058N58DSBalliet Edgar J III · Northampton, PABuilt 1979 · S/N 17272305N58FSClark Mitchell P R · Drewsey, ORS/N 2108N58GSzarek Evelyn Personal Representative · Fairbanks, AKBuilt 1957 · S/N 680-519-189N58GMWanless Dax D · Granite Falls, MNS/N 153
Back to AD 90-04-06 R1