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.

N7109LSimpson Brian · Indian Trail, NCS/N AA5-0409N7109QLawless Bruce A · Lago Vista, TXBuilt 1972 · S/N 17260409N7109SCitation Companeros LLC · Seguin, TXBuilt 1999 · S/N 2952N7109UOyler Joseph B · Kokomo, INBuilt 1964 · S/N 2739N7109WV1 Air Inc · Hibbing, MNS/N 28-897N710APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843766N710BWise Matthew A · Chambersburg, PABuilt 1990 · S/N 20017N710BJBluebird LLC · Vestavia, ALBuilt 2003 · S/N 60062N710CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881730N710CBPruitt Ron A · Stoneville, NCBuilt 1980 · S/N 1N710CTGibson William V · Aberdeen, MSBuilt 2000 · S/N 80451N710EHRatcuffe Howard Clark · Huntsville, UTBuilt 2000 · S/N 23446N710FGKimbrell Jeffrey L · Greenville, SCBuilt 1970 · S/N 177RG0016N710GMaj Enterprises LLC · Missoula, MTBuilt 2013 · S/N 460N710JFStearns Todd C · Cora, WYBuilt 2008 · S/N J-001N710LGCollette John D · Las Vegas, NVS/N 710N710MEQualitair LLC Trustee · MichelstadtBuilt 1971 · S/N 39-101N710PXAura LLC · Frederick, MDBuilt 2006 · S/N 81788N710RDPurll Samuel B · Mechanicsville, MDBuilt 1966 · S/N 28-21809N710SPElite Approach LLC · Chesterfield, MOBuilt 1999 · S/N 172S8106N710TLBarker John Van · Smyrna, GABuilt 2007 · S/N 1398-2007N710UBoard Of Regents Of University Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020229N710VEFour With Two LLC · San Francisco, CABuilt 2003 · S/N 70254N7110BSeven-Eleven Brick Inc · Dalton, MNBuilt 1956 · S/N 22-4327N7110LNorris Bobby L · Ocala, FLBuilt 1976 · S/N AA1B-0610N7110PTobias Gregory L · Ottawa Lake, MIBuilt 1960 · S/N 24-2267N7110QLawson Virgil · Sylvar Grove, KSS/N 17260410N7110RQuale Eric L · Everett, WABuilt 1966 · S/N 28-21806N7110YFaust Stanley J · Nashua, NHBuilt 1963 · S/N 30-129N7111DKeyt Jeffrey D · New Providence, NJBuilt 1957 · S/N 22-4969N7111NAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 1977 · S/N 17269101N7111RGreen Michael W · Helena, ARS/N 28-21810N7111YBritt Robert J · Au Gres, MIBuilt 1963 · S/N 30-130N71128Eastern Stearman Inc Trustee · Leesburg, VABuilt 1972 · S/N 28-7225450N7112CEmbry Vantha C · Knoxville, TNS/N 28-7690056N7112GHooper Walter E III · Spring City, TNBuilt 1969 · S/N 17258812N7112KHamann Hunter R · Spokane, WABuilt 1950 · S/N 18-329N7112LDoskicz Harry N · Slatington, PAS/N AA5-0612N7112RMarshall Air LLC · Bellevue, MIBuilt 1966 · S/N 28-21811N7112WKeesee Bill · Meadow, TXBuilt 1962 · S/N 28-903N7113DN7113d LLC · Ardmore, OKBuilt 1957 · S/N 22-4971N7113KSavland Andy M · Hoonah, AKBuilt 1950 · S/N 18-332N7113LBlanton Ronald · Lascassas, TNBuilt 1974 · S/N AA5-0675N7113PWallace Lonnie Roy · Charlotte, NCBuilt 1960 · S/N 24-1879N7113QMiles Michael G · Hillsborough, NCBuilt 1972 · S/N 17260413N7113RNewton Dennis E · Surprise, AZBuilt 1966 · S/N 28-21812N7113WHigh Flyers Inc · Benson, AZS/N 28-961N71141Av8 Flight Assets LLC · Eden Prairie, MNBuilt 2017 · S/N 2843910N71143Av8 Flight Assets LLC · Eden Prairie, MNBuilt 2017 · S/N 2843911N7114AMy Air Mira LLC · Eagan, MNBuilt 2017 · S/N 2843912
Back to AD 90-04-06 R1