OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,375

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.

N26796Rivers Robert W · Savannah, GABuilt 1978 · S/N AA5A0581N26799Barton Steve K · Canon City, COBuilt 1978 · S/N AA5A0734N267AAWings Over Texas Holdings LLC · Denton, TXBuilt 2019 · S/N 4496482N267AGSimply Living LLC · Fort Myers, FLBuilt 1974 · S/N 28-7425114N267CMRegistered aircraftBuilt 1954 · S/N 18-3532N267DHInternational Air Services Inc Trustee · Carson City, NVBuilt 1982 · S/N 28-8190141N267DPCarrasco Mario G · Glendora, CABuilt 1967 · S/N 28-22673N267GSArnold Airplane LLC · North Branch, MNBuilt 1994 · S/N 737-94N267MSweetman Gary S · Wolcott, CTBuilt 2006 · S/N 90607N267MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881365N267MTPlane Fun Inc Tr Trustee · Snellville, GABuilt 1974 · S/N 0005N267NDPlane Nonsense Inc · Middletown, DEBuilt 1999 · S/N 2842067N267RWKoelzer Galen G · Othello, WABuilt 1964 · S/N 0047N267WKKuemmerle Walter M · Altha, FLBuilt 2023 · S/N 3414N267WSErvin Andrew · Centennial, COBuilt 1966 · S/N 1000N267WYN267wy LLC · Mansfield, TXBuilt 2025 · S/N 3452N26800Registration Pending · Peyton, CORegistration pendingS/N AA5A0735N26805Barry Robert J · Gresham, ORBuilt 1978 · S/N AA5A0737N2680MRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1977 · S/N 28-7890261N2680TAviyon Aviation LLC · Orlando, FLBuilt 1971 · S/N 28-7225085N2680WNielson Michael James · Spanish Fork, UTBuilt 1966 · S/N 1001N2680ZEaston Christopher J · Burlington, MABuilt 1977 · S/N 1010-78N26810Whiting Mark D · Champaign, ILBuilt 1940 · S/N 4190N26813Weingart Matthew S · Port Charlotte, FLBuilt 1978 · S/N AA5A0738N26814Desert Cat Aviation LLC · Tempe, AZBuilt 1978 · S/N AA5A0739N2681AKatzmarek Clay M · Wasilla, AKS/N 18-2186N2681CBlack Deberah L Trustee · Las Vegas, NVBuilt 1963 · S/N 18-8004N2681MHebrink Jason R · Grand Rapids, MNBuilt 1946 · S/N 12-1112N2681PFlitner Colten · Greybull, WYBuilt 1955 · S/N 18-4368N2681WAb Mooney LLC · Durham, NCBuilt 1966 · S/N 3319N2681ZOchsenbauer Thomas G · Forest Lake, MNBuilt 1978 · S/N 1011-78N26822Terrier Douglas A · Southlake, TXBuilt 1978 · S/N AA5A0742N26825Redline Aerospace LLC · Kalispell, MTS/N AA5A0744N26829Parr Russell R · Auburn, WABuilt 1978 · S/N AA5A0747N2682MDavis Philip L · Spring Hill, TNBuilt 1946 · S/N 12-1113N2682TMorrison James S · Bergen, NYBuilt 1971 · S/N 28-7225086N2682ZEmslie Donis A · West Lafayette, OHBuilt 1978 · S/N 265-78N26830Butcher Alden K · Jane Lew, WVBuilt 1978 · S/N AA5A0748N26831Horn Charles R Jr · Avondale, AZBuilt 1978 · S/N AA5A0749N26839Brown Timothy · Plainfield, INBuilt 1978 · S/N AA5A0756N2683ALovett Andre D · Anchorage, AKBuilt 1953 · S/N 18-2189N2683MBeach Banners Inc · Jacksonville, FLBuilt 1946 · S/N 12-1114N2683TSojourn Flyers Inc · Chebanse, ILBuilt 1971 · S/N 28-7205082N2683VPeters Robert M · Fremont, INBuilt 1975 · S/N 177RG0655N2683WSabagh Steve B · Maricopa, AZBuilt 1966 · S/N 1002N2683ZAmmlim LLC · Vacaville, CABuilt 1978 · S/N 1227-78N26840White Mary · Thurmont, MDS/N AA5A0757N26841Flying A Aviation LLC · Archer City, TXBuilt 1940 · S/N 4210N26845Thornton Charles A · Collinsville, ILS/N AA5A0761N26847Anderson Wayne D · Providence Forge, VAS/N AA5A0762
Back to AD 90-04-06 R1