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.

N11677Irby Darrell · Keller, TXBuilt 1972 · S/N 306-72N11679King Nathan A · Dunkirk, MDBuilt 1972 · S/N 307-72N1167CMountain Bluebird Aviation LLC · Kalispell, MTBuilt 1953 · S/N 22-992N1167PCascadia Air Ventures Inc · Winlock, WABuilt 1955 · S/N 23-181N1167XHoover Adam A · Sugarloaf, PABuilt 1975 · S/N 28-7525295N11680Adams Jonathan · Columbia, MOBuilt 1972 · S/N 21-72N11681Amelia Reid Aviation LLC · San Jose, CABuilt 1972 · S/N 308-72N11683Osborne Barry G · Brainerd, MNBuilt 1972 · S/N 852-72N11684Pepper Richard V · Henderson, TXBuilt 1972 · S/N 309-72N11686Hopewell Jeffrey D · Temple, TXS/N 310-72N11687Young William A · Delta Junction, AKBuilt 1972 · S/N 313-72N1168CPartridge James R · Chino Valley, AZBuilt 1953 · S/N 22-994N1168LDepaul Thomas J · Juneau, AKBuilt 1966 · S/N 330N1168PLangford Michael J · Middletown, MDS/N 3703N1168XJz Air LLC · Brooklyn, NYBuilt 1975 · S/N 28-7505219N1169Downes Pamela · Chino Hills, CABuilt 1956 · S/N 390N11690Evers William J · Sussex, WIBuilt 1972 · S/N 355-72N11693Miller Robert A · Auburn, CAS/N 853-72N11695Rvi Aviation LLC · Clay Center, KSBuilt 1972 · S/N 856-72N1169AK-Air Service LLC · Gakona, AKBuilt 1951 · S/N 18-767N1169HSwihart Matthew Allen · San Marcos, TXBuilt 1975 · S/N AA5B-0063N1169RClayton Alfred T Jr · Anchorage, AKBuilt 2007 · S/N 004N116AJJewett Chris E · Lexington, SCBuilt 2004 · S/N DC03N116ARLower Timothy C · Biglerville, PABuilt 1997 · S/N 24850N116ATTrevisan Hugo S · Polk City, FLS/N 38-78A0731N116AVValleortiz Hector J · Laurel Hill, NCBuilt 1984 · S/N 28-8416094N116BBretana Charles Jr · Prescott, AZS/N E006N116BHBighorn Airways Inc · Sheridan, WYBuilt 1963 · S/N 18-8041N116BWButler Ross W · Jackson, CABuilt 2001 · S/N 24986N116CCCrawford E Clarke · Flagstaff, AZBuilt 1992 · S/N 824N116CRConti Christine M · Plantation, FLBuilt 1976 · S/N 17266985N116DHHoover David · Foster City, CAFirst renewal noticeBuilt 1990 · S/N 0001N116DPPaup Dennis C · Carroll, IABuilt 2006 · S/N 70194N116DWWalters Douglas B · Templeton, CABuilt 2020 · S/N 21807N116ESOlson Edward H · Elizabeth, COBuilt 2021 · S/N 5N116FLMerdes Gordon B · Corpus Christi, TXBuilt 1974 · S/N 18-7509029N116FPRandall David J · Balsam Lake, WIBuilt 1978 · S/N 17271241N116FRCloverfield Aero LLC · Los Angeles, CABuilt 2014 · S/N 2844150N116GSTharp Thomas J · Nampa, IDBuilt 2001 · S/N 1298009N116JMMorgan James E · Everett, WABuilt 2009 · S/N RV20260N116JTParks Kevin J · Arlington, TNBuilt 2009 · S/N 80982N116KSKent State University · Stow, OHBuilt 1999 · S/N 17280820N116MRDibuono Michael · Clearwater, FLBuilt 2025 · S/N 0700N116MSArps Alan D · Schuyler, NEBuilt 1997 · S/N 203N116NJUsda Forest Service Fepp · Trenton, NJBuilt 1964 · S/N 18-8104N116PMiller Robert J · Casselton, NDBuilt 1977 · S/N M79470N116PCGlobal Piloting Solutions LLC · Mankato, MNBuilt 2001 · S/N 1320-2001N116PGUnusual Attitudes LLC · Bates City, MOBuilt 2004 · S/N 3547N116PWRm Construction LLC · Greeley, COS/N 116N116QCigarroa Jorge J · Laredo, TXBuilt 1997 · S/N 1360
Back to AD 90-04-06 R1