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.

N5918QNorheim Bjoern T · Phoenix, AZBuilt 1965 · S/N 824N5918VKnutson Sever B · Hutchinson, MNBuilt 1977 · S/N 28-7790513N5918WLathrop Patrick W · Kent, WABuilt 1966 · S/N 28-3189N5919HKidder Robin G · Burlington, KYS/N 16-543N5919LMckee Marty R · Lenoir City, TNBuilt 1969 · S/N AA1-0219N5919QBig Sky Adventures LLC · Nicholasville, KYS/N 3168N5919UDewater Mark · Mulberry, ARBuilt 1970 · S/N 28-26561N591JPReed Douglas W · Kingwood, TXBuilt 1976 · S/N AA5B0361N591PHKingdom Air Corps · Sutton, AKBuilt 1966 · S/N 670041N591RVSims David L · Mc Alpin, FLBuilt 2025 · S/N 93270N591TXSchechter Andrew M · Goshen, OHBuilt 2022 · S/N 001N5920DBates Matthew T · Springfield, VABuilt 1956 · S/N 22-4582N5920HZakrzewski Patrick J · Waterford, WIBuilt 1949 · S/N 16-532N5920LSharratt Mark M · Ogilvie, MNBuilt 1969 · S/N AA1-0220N5920QKellogg Annabelle S · Cumming, GABuilt 1965 · S/N 825N5920WSynergy Aviation LLC · Greer, SCBuilt 1966 · S/N 28-3223N5921HHoehne Michael G · Vienna, VABuilt 1949 · S/N 16-542N5921PFiscus Ryan K · Burleson, TXBuilt 2022 · S/N 059N5921WStearns Edwin Ben Jr · Eloy, AZS/N 28-3227N5922EAerial Scouting Solutions LLC · Sioux Center, IABuilt 1978 · S/N 17271963N5922FNeel Aviation LLC · Lakeland, FLBuilt 1976 · S/N 28-7715158N5922HGifford Gary W · Lighthouse Point, FLS/N 16-544N5922LJokerst Kenneth · Saint Louis, MOBuilt 1969 · S/N AA1-0222N5922PWiseman Transport LLC · Henderson, TXBuilt 1959 · S/N 24-1009N5922UPagan Jose A · Kokomo, INBuilt 1970 · S/N 28-26408N5922ZBellamy John Mark · Freeville, NYBuilt 1964 · S/N 22-9791N59231Widewings LLC · Alexandria, VABuilt 1942 · S/N 75-4367N5923LKane Christopher M · Sacred Heart, MNS/N 7GC-80N5923WPremier Pilots LLC · Herriman, UTBuilt 1966 · S/N 28-3246N5924FN5924f LLC · Cocoa, FLS/N 28-7715159N5924QWright Andrew · Sacramento, CABuilt 1965 · S/N 827N5924UOrganization Of Black Aerospace Professionals Inc · Westchester, ILBuilt 1970 · S/N 28-26815N5924WPribbenow Dennis A · Payson, AZBuilt 1966 · S/N 28-3273N59262Tabbert William Stanley · Diamondhead, MSS/N F-2N5926BAddington Ralph P · Orlando, FLS/N 90712N5926DToste Greg · Newcastle, CABuilt 1956 · S/N 22-4589N5926FRegistered aircraftBuilt 1976 · S/N 28-7790143N5926UIron Flyer Of Cuzamil LLC · Lewes, DES/N 28-26739N5926WLeonard Jeffrey A · Bakersfield, CABuilt 1966 · S/N 28-3311N5927HParley Michael D · Carmel, CABuilt 1949 · S/N 16-549N5927LTri State Airmotive LLC · Berryville, ARBuilt 1969 · S/N AA1-0227N5927PSchlup John R · Booneville, ARBuilt 1959 · S/N 24-1015N5927WKochling Christopher · Houston, TXBuilt 1966 · S/N 28-3331N5928EGace Flying Club Inc · Ronkonkoma, NYBuilt 1978 · S/N 17271964N5928JParsons Royson A · Atascadero, CABuilt 1971 · S/N A1500228N5928QSchmidt Tyren A · Albertville, MNBuilt 1965 · S/N 829N5928WRegistered aircraftN-number assigned, not yet registeredS/N 28-3367N5929WEdwards Allan · Leesburg, VABuilt 1966 · S/N 28-3368N5929ZBrown Dave M · Crescent City, CABuilt 2013 · S/N 75-8517N592CJAims Community College · Greeley, COBuilt 2019 · S/N 2881183
Back to AD 90-04-06 R1