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.

N8607YMs Aero Inc · Lakeville, OHBuilt 1968 · S/N 30-1747N8608DYoung Mike · Albany, CABuilt 1957 · S/N 22-5806N8608VBenter Neil W · Ambrose, NDBuilt 1974 · S/N 154-75N8609NBird Properties LLC · Roosevelt, UTBuilt 1971 · S/N 28-7105148N8609VRegistration Pending · Frontenac, MNRegistration pendingBuilt 1974 · S/N 1083-75N860ACAri Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881385N860CPChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280557N860PARe Elite Aviation LLC · Hialeah, FLBuilt 1981 · S/N 17274865N860SASaint Clair Flight Academy Inc · Richmond, MIBuilt 2001 · S/N 172S8860N860SCFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881743N860SPRegistered aircraftBuilt 1999 · S/N 172S8131N860TCNorth Star Aviation Inc · Mankato, MNBuilt 2016 · S/N 2842417N860UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020195N8610CRuss Robert P · Van, TXBuilt 1953 · S/N 22-1293N8610NSkipper Donald J · Huntersville, NCBuilt 1971 · S/N 28R-7135131N8610RTener Dean R · Lisbon, OHBuilt 2023 · S/N 91918N8611VAlbright Harold R · Dubois, WYS/N 155-75N8611YCragg Gordon E · Georgetown, TXBuilt 1968 · S/N 30-1751N8612DPerry Leonard M · Soldotna, AKBuilt 1957 · S/N 22-5812N8613DPerry Kenneth V · Katy, TXS/N 22-5811N8613VBoley Trevor T · Palmer, AKS/N 804-75N8614CErdmann Adam C · Raseau, MNBuilt 1953 · S/N 22-1295N8614YD&D Maintenance LLC · Etna Green, INBuilt 1968 · S/N 30-1754N8615VCitabria N8615v LLC · Westminster, COBuilt 1975 · S/N 504-75N8615YUniversity Of Alaska Anchorage · Anchorage, AKBuilt 1968 · S/N 30-1755N8616DFrancis Harvey B · Key West, FLS/N 22-5815N8616VPittman Michael · Goodridge, MNS/N 808-75N8617DGrisham Michael H · Paulden, AZBuilt 1957 · S/N 22-5820N8617HToutant Roland J · Woodstock, CTBuilt 1981 · S/N 701N8617YBurton David A · Pepperell, MABuilt 1981 · S/N 1500N86181Neel Bradley H · Lakeland, FLBuilt 1946 · S/N 11AC-611N86183J L Air LLC · Wilmington, DEBuilt 1981 · S/N 1506N8618YGroup Aire II · Manitowoc, WIBuilt 1968 · S/N 30-1758N86198Styer David B · Pendleton, ORBuilt 1981 · S/N 521-2N8619ACowboy Up Aviation LLC · Frenchglen, ORBuilt 1981 · S/N 705N8619DBenton Mark H · Sussex, WIBuilt 1957 · S/N 22-5822N8619EHogan Daniel L · Chapel Hill, NCBuilt 1976 · S/N 28-7625143N8619VPlane Folks LLC · Tucson, AZBuilt 1975 · S/N 809-75N8619YNuse Aviation LLC · Hollidaysburg, PABuilt 1968 · S/N 30-1759N861ACGuglietta Glenn W · Payson, AZBuilt 2000 · S/N 861-2000N861APKlein Edwin Andrew Bell · Grass Valley, CABuilt 1957 · S/N 22-4769N861CHPope James D · Lewiston, IDBuilt 2000 · S/N 3156N861MMGiordano Matthew J Jr · Wilmington, DEBuilt 2012 · S/N 81834N861PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843945N861PAParis Air Inc · Vero Beach, FLBuilt 1973 · S/N 347450063N8620CLrh Equipment LLC · Pendleton, ORS/N 706N8620DMid Atlantic Air Museum · Reading, PAS/N 22-5823N8621DBrown Lonnie S · Lone Jack, MOBuilt 1957 · S/N 22-5824N8621EUpdraft Leasing LLC · Tea, SDBuilt 1976 · S/N 28-7615143N8621YParks Ashton · Pepperell, MABuilt 1968 · S/N 30-1762
Back to AD 90-04-06 R1