OpenAirDocs.org
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.

N26247Royer Virgil P · Salem, ORBuilt 1977 · S/N AA5A0482N2624AWsiaki Kenneth J · Northridge, CABuilt 1953 · S/N 22-1091N2624NBoston Helicopters Inc · North Andover, MAS/N 0739N2624PRobinson Eric C · Palmer, AKS/N 22-2960N2624WWilkins James K · Owens Cross Roads, ALBuilt 1966 · S/N 966N26253Tompkins Robert G · Panacea, FLBuilt 1979 · S/N AA5A-0819N26255Wren Donald F · West Chester, OHBuilt 1977 · S/N AA5A0485N2625AGundersen James I · Townsend, MTBuilt 1952 · S/N 18-2170N2625CL&W Leasing LLC · Murfreesboro, TNBuilt 1998 · S/N 17280436N2625WPatton William D · Sheridan, WYBuilt 1966 · S/N 967N26265Rogers B L · Martinsburg, WVBuilt 1940 · S/N 7552N2626BRodgers Patti · Apple Valley, CABuilt 2004 · S/N 90429N2626PLeguia Augusto A · Kathleen, GABuilt 1955 · S/N 22-2963N26273Gasiorowski Mark A · Buford, GABuilt 1977 · S/N AA5A0500N26275Bresser Jason R R · Soldotna, AKS/N 7559N26278Bal-Air LLC · Boca Raton, FLBuilt 1977 · S/N AA5A0502N2627MN2627m LLC · Rehoboth Beach, DEBuilt 1988 · S/N 755MN2627NCartwright Josh D · Salem, MOBuilt 1988 · S/N 0756N2627WDiamond Engineering & Service Co · Granger, INBuilt 1966 · S/N 3297N26284Rupke Curtis · Winterville, NCS/N 7570N2628GArsenault Donald S · Round Rock, TXBuilt 1967 · S/N 53N2628PCraig Richard L · Sonoma, CAS/N 22-2965N2628ZSipes Gary C · Livingston, TXBuilt 1988 · S/N 0773N26292Qualitair LLC Trustee · MichelstadtBuilt 1977 · S/N AA5A0508N26293Proclaim Aviation Ministries · Worthington, MNBuilt 1940 · S/N 7581N26294Dennen Corey M · Troup, TXS/N AA5A0509N26295Mott William R · Beach Lake, PABuilt 1940 · S/N 7582N26297Hunter Danny L · Gulfport, MSBuilt 1977 · S/N AA5A0510N26298Champaign Sharon E · New Holstein, WIBuilt 1977 · S/N AA5A0511N26299Ferraris Robert · Tinton Falls, NJBuilt 1977 · S/N AA5A0512N2629VEyw Flying LLC · Key West, FLBuilt 1974 · S/N 177RG0635N2629WHogan James C DBA · Cameron Park, CABuilt 1966 · S/N 970N262ACLavelle Jeffrey · Kenmore, WABuilt 1996 · S/N 766-96N262AMChapman Kevin Joseph · Williston, NDBuilt 2004 · S/N 2262N262CBCalifornia Baptist University · Riverside, CABuilt 2018 · S/N 2881005N262E349 Ez LLC · Yakima, WABuilt 1984 · S/N 262N262EEHorizon Flights Corp · Henderson, NVBuilt 1973 · S/N 17261621N262ERRoseville Aviation LLC · Roxboro, NCBuilt 1975 · S/N 17263854N262ESBreshears Michael · San Antonio, TXBuilt 1986 · S/N 425N262GRDr I T Help LLC · Cheyenne, WYBuilt 1996 · S/N 21387N262LHNeo Helicopter Academy LLC · North Royalton, OHBuilt 2009 · S/N S1926N262LNWave Shack Acquisitions LLC · Palm Coast, FLBuilt 2014 · S/N 001N262MGordon Bruce · Marstons Mills, MABuilt 1976 · S/N 17268356N262MVCavanaugh Charters Inc · Addison, TXBuilt 1958 · S/N 2232N262NDMoore Aviation Inc · Beaver Falls, PABuilt 1999 · S/N 2842061N262PDGritter Richard J · Catlett, VABuilt 1991 · S/N 01N262PEPorter Randall L · Athol, IDBuilt 1971 · S/N 492N262R262r LLC · Richland, WABuilt 1966 · S/N 28-21931N262RMDisrud Roger G · Olathe, KSBuilt 2002 · S/N 80153N262SASundance Airport LLC · Yukon, OKBuilt 1967 · S/N 28-4047
Back to AD 90-04-06 R1