OpenAirDocs.org
AD 98-21-21 R1

Registered aircraft · 85,620

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:98-21-21-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:98-21-21-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.

N1700CKrause Kade G · Jackson, MTBuilt 1953 · S/N 30400N1700DJohnson Robert Kenneth · Monte Rio, CABuilt 1951 · S/N 20143N1700JStratus Aviation LLC · Newnan, GABuilt 1967 · S/N 28-24107N1700XRegistered aircraftBuilt 1954 · S/N D-3866N1701Rolston Charles W · Shoreview, MNBuilt 1964 · S/N 17252418N1701DBlue Skies Aero LLC · Clovis, CABuilt 1981 · S/N 24-1156N1701EValiair Limited Co Trustee · Casper, WYBuilt 1978 · S/N 32R-7885002N1701RM R Planes LLC · Redmond, WABuilt 1974 · S/N 18502423N1701TRd Aire LLC · Opelika, ALBuilt 1970 · S/N 28-7125018N1701VBeach Chad T · Kilgore, TXBuilt 1974 · S/N 17262851N1701WJagz Aviation LLC · Akron, OHS/N D-9394N1702CCork Dennis R · Soldotna, AKBuilt 1953 · S/N 30402N1702EExecutive Flight Institute LLC · Murrieta, CABuilt 1978 · S/N 17271101N1702HHesston College · Hesston, KSBuilt 1977 · S/N 28-7790336N1702RDaniel Boone Flying Club Inc · Booneville, MOBuilt 1978 · S/N R18200523N1702TDans Shop Inc · Montevideo, MNBuilt 1963 · S/N TC-527N1702VClassic Rotors Museum · Ramona, CABuilt 1974 · S/N 17263717N1703JCogan Betty C · Bristol, TNBuilt 1968 · S/N 28-24111N1703MNesloney Thomas Jeffery · Hilltop Lakes, TXBuilt 1975 · S/N 18264417N1703TAlicea Ismael · Iselin, NJBuilt 1970 · S/N 28-7125019N1703WNeimeier Henry P · Bowling Green, KYBuilt 1971 · S/N D-9303N1704DSykes Gregory P · Arlington, WABuilt 1951 · S/N 20147N1704QOlfert Ronald W Trustee · Frazer, MTS/N 18257248N1704TLavieri Gary P · Seneca, SCBuilt 1970 · S/N 28-7125020N1704WNiskanen Michael · Framingham, MABuilt 1972 · S/N TC-1486N17053Rough Joseph W · Priest Lake, IDBuilt 1953 · S/N 25678N17059N79107 LLC · Orrville, OHBuilt 1982 · S/N R18201915N1705DSchultz Jeffrey J · Wasilla, AKBuilt 1951 · S/N 20148N1705FTennis Gayland L · Bath, MIBuilt 1966 · S/N 17255100N1705GDavis Roger N · Cheshire, ORBuilt 1962 · S/N CD-479N1705JPeel William · Gilbert, AZBuilt 1968 · S/N 28-24113N1705MYeager Jacob M · Ignacio, COBuilt 1975 · S/N 28R-7535260N1705RCox Brian Allen · Pasadena, CABuilt 1978 · S/N R18200525N1705TLubeski Lawrence J · Lapeer, MIBuilt 1970 · S/N 28-7125021N1705VNiles Air LLC · Concord, NCBuilt 1974 · S/N 17263718N1706DMaser Matt P · Junction City, ORBuilt 1952 · S/N 20149N1706GBarcenas Shawn · Weirsdale, FLBuilt 1962 · S/N TC-274N1706JSkycastle Flying Club Inc · New Castle, INBuilt 1968 · S/N 28-24114N1706TMarshall Loraine · Independence, KYS/N 28-7125022N1706WHinton Bay Management LLC · Jackson, WYBuilt 1972 · S/N E-366N1707Qualitair LLC Trustee · MichelstadtBuilt 1977 · S/N 24-0263N17079Speakman Donna M · Auburn, ALBuilt 1965 · S/N 28-2157N1707DMorse David M · Kernersville, NCBuilt 1951 · S/N 20150N1707FFreije Anthony M · Anchorage, AKBuilt 1966 · S/N 17255102N1707HCyberflight Inc · Wilmington, DEBuilt 1977 · S/N 28R-7737010N1707TMoore Merritt T II · Silver Creek, NYBuilt 1955 · S/N 23-299N1707WRussell Marc R · Simi Valley, CABuilt 1972 · S/N E-367N1708CHaggard Roy A · Murrieta, CABuilt 1953 · S/N 30408N1708FKnudsen Mark A · Whitmore Lake, MIBuilt 1966 · S/N 17255103N1708RHall Alan D Trustee · Big Bear Lake, CABuilt 1974 · S/N 18502430
Back to AD 98-21-21 R1