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.

N1444XWaddell Charles · Elk Grove, CABuilt 1975 · S/N 28R-7535283N1445ESouth Aero LLC · Albuquerque, NMBuilt 1978 · S/N 17271004N1445TWhelan And Sons Realty LLC · Suffield, CTBuilt 1972 · S/N 28R-7235290N1446KColeman James P · Sand Springs, OKBuilt 2015 · S/N 8214N1446XN15956 Inc · Wilmington, DEBuilt 1975 · S/N 28-7525317N14470Girty Kenneth G · Enid, OKS/N 558N1447HMarkovich David E · Eden Prairie, MNBuilt 1977 · S/N 28-7725144N1447JCapital Auto Sales · Hickman, NEBuilt 1976 · S/N 447N1447TDa Silva Paulo E · Orlando, FLS/N 28R-7235292N1447XGaventa Edward J · Logan Twp, NJBuilt 1975 · S/N 28-7525318N1447ZHildebrand Dean A · Mesquite, TXBuilt 2012 · S/N 73178N1448RWright Roger W · Buckeye, AZBuilt 1975 · S/N AA1B-0548N1448XMallett Robert T · Wilmington, MABuilt 1975 · S/N 28-7505229N1449Registered aircraftBuilt 2007 · S/N 7086N1449EChase Matthew S · Rock Hill, SCBuilt 1978 · S/N 17271005N1449JAlpha Zulu Aviation LLC · Paragould, ARS/N 449N1449UInternational Aviation Group LLC · Lake Wales, FLBuilt 1976 · S/N 17267116N1449VLogsdon Timothy D · Livermore, CABuilt 1974 · S/N 17263586N1449WRitel Copter Service Inc · Hudson, IABuilt 1969 · S/N 7931N144AMStardust Aviation LLC · Farmingdale, NYBuilt 2021 · S/N 28020016N144AZBartosh Jason R · Big Pine Key, FLBuilt 1995 · S/N 21911N144BCThomas George E · Rice, WAS/N 188N144BFHyldburg Aviation Inc · Plymouth, MABuilt 1974 · S/N 17264101N144CCNightingale William T III · Rancho Cucamonga, CABuilt 1975 · S/N AA5B-84N144CPHobgood Mitch D · Tylertown, MSBuilt 2024 · S/N 20420N144DFPessel William O Jr · Princeton, NJBuilt 1993 · S/N 1907N144DHSky 1 Inc · Wilmington, DEBuilt 1996 · S/N 1219-96N144DNSimmons Donald L · Bonita Springs, FLBuilt 1996 · S/N 2262N144DRSchneider Robert Keith · Bolivar, TNS/N 23587N144DVAnderson Darrell L · Great Falls, MTBuilt 2016 · S/N 2850N144JMBavarian Barnstormers 2 Inc · North Fort Myers, FLBuilt 1967 · S/N 18-8589N144KTBibb Richard E · Locust Grove, VABuilt 1997 · S/N 1187N144LDSchwartz Daniel James · Lannon, WIBuilt 2000 · S/N 4080N144LLLechner Larry A · Ithaca, NYS/N RV4-3753N144MCoad Aeronautics LLC · Saint Jacob, ILBuilt 1978 · S/N 38-78A0596N144MBBoarman Mark A · Clarkdale, AZBuilt 2007 · S/N 2866N144MC450 Dancer LLC · Benton Harbor, MIBuilt 1967 · S/N 28-22804N144MRRegistered aircraftBuilt 1983 · S/N 195N144PHDel Rio Aviation Inc · Paso Robles, CABuilt 1991 · S/N S1517N144PJMccorkle Clayton Jeffry · San Antonio, TXS/N 450N144RDMullins Steve D · Springfield, MOBuilt 1994 · S/N BP-1N144RLHanshew James M · Phoenix, AZS/N AA5B1034N144RUG&M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N 44-7995323N144RVTanner Roger J · Rosamond, CAFirst renewal noticeBuilt 1991 · S/N 1N144SHHarris Steven L Trustee · Sisters, ORBuilt 2001 · S/N 1N144TCSemeneshen Edmund · Lisbon, CTBuilt 1978 · S/N 38-79A0119N144TLNielson Mark Allen · Willmar, MNBuilt 1959 · S/N 24-1205N144TMSale Reported · Crystal, MNSale reported, pending cancellationBuilt 2004 · S/N M-II-1898N144TPAndrews Clark N · San Diego, CABuilt 1974 · S/N 144N144VAVans Aircraft Inc · Aurora, ORBuilt 2015 · S/N 140055
Back to AD 90-04-06 R1