AD 90-04-06 R1

Registered aircraft · 68,369

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.

N26082Hunt Edmond L · Madison, WVBuilt 1977 · S/N AA5A0420N26085Van Nostran Seth A · Doylestown, OHS/N 4023N26086Joe Hoerter LLC · Hilton Head Island, SCBuilt 1977 · S/N AA5A0326N26087Enger Kenneth H · Mesa, AZBuilt 1977 · S/N AA5A0421N2608GStrom Gordon B Md · Paris, TXBuilt 1967 · S/N 450N2608MEhrenfelt Linda Mae · Pierre, SDBuilt 1946 · S/N 12-1074N26094Hall George M · Blooming Grove, TXBuilt 1977 · S/N AA5A0422N26098Chaput Armand J · Austin, TXBuilt 1977 · S/N AA5A0423N2609EMakotyn Andrzej · Northbrook, ILBuilt 1978 · S/N 38-78A0486N260EMMartin Edward I · Trinity Center, CAS/N 260EMN260EZMurphy John F · Ann Arbor, MIBuilt 1991 · S/N 260N260FAStratus Rr LLC · New Castle, DEBuilt 2026 · S/N 28020258N260JEMccutchen David W · Dickson, TNS/N JE-1N260JKKnight John S · Brewer, MEBuilt 2024 · S/N 806RN260NDPlane Nonsense Inc · Middletown, DEBuilt 1999 · S/N 2842055N260RGKelley Jacob Scott · Vail, AZBuilt 2024 · S/N 400N260RJHitterman James D · Metropolis, ILBuilt 1982 · S/N 1N260SGEsteban Granwel Genio Jr · Johnson City, TNBuilt 2014 · S/N 35N260UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020225N260VMMaday Matthew · Tahlequah, OKBuilt 1971 · S/N MC 91N26100Carey International Aviation Services LLC · Rockville Centre, NYBuilt 1977 · S/N AA5A0424N26103Williams Richard · Atlanta, GABuilt 1977 · S/N AA5A0426N26104Sumner Gary W · Knoxville, TNBuilt 1977 · S/N AA5A0402N26106Polymer Depot LLC · Delafield, WIBuilt 1977 · S/N AA5A0427N2610AGreen-Way Essentials LLC · Arkansas City, KSBuilt 1952 · S/N 22-891N2610RStable Aviation LLC · Eagan, MNBuilt 1969 · S/N 28R-35229N26114Flyinisme LLC · Saint Augustine, FLBuilt 1977 · S/N AA5A0433N26116Fasske Wayne · Crossville, TNBuilt 1977 · S/N AA5A0437N2611PRegistered aircraftBuilt 1978 · S/N 880N26120Houk David A Jr · Norton, OHBuilt 1977 · S/N AA5A0441N26122Smile Givers · Chico, CABuilt 1977 · S/N AA5A0443N26124Chapman Edward J DBA · Jordan, MNBuilt 1977 · S/N AA5A0444N26127Rose David Alan · Port Orange, FLBuilt 1977 · S/N AA5A0446N2612MGreenhalgh Janna L · Caldwell, IDBuilt 1946 · S/N 12-964N2612ZStewart Jon L · Walker, MNBuilt 1977 · S/N 1002-77N26130Bokkers Maike L · Mountain View, CABuilt 1977 · S/N AA5A0447N26132Active Pilot Solutions Inc · Van Nuys, CABuilt 1975 · S/N 28-7515443N26136Aoki Nidal · Porter, TXBuilt 1977 · S/N AA5A0452N2613PBraun Daniel R · Damascus, ORS/N 22-2948N26142Stamper George William III · Quinton, VABuilt 1977 · S/N AA5A0454N2614ADixon Eric A · Salado, TXBuilt 1952 · S/N 22-896N2614DRegistration Pending · Kerrville, TXRegistration pendingBuilt 1987 · S/N 0727N2614GNorthern Air Inc · Bonners Ferry, IDBuilt 1967 · S/N 64N2614VMorris Daniel J · Bossier City, LABuilt 1974 · S/N 177RG0632N2615MKelsey Mike · Carey, IDBuilt 1946 · S/N 12-1079N2615WSturgis Joel B · Pensacola, FLBuilt 1965 · S/N 3292N26160Wilson William J · Houston, TXBuilt 1977 · S/N AA5A0455N26163Brown Michael D · Elk Grove, CABuilt 1977 · S/N AA5A0456N26165Moldt Richard W · Montrose, CAS/N AA5A0457N26167Mowery Ronnie G · Spencer, OHBuilt 1977 · S/N AA5A0461
Back to AD 90-04-06 R1