OpenAirDocs.org
AD 98-21-21 R1

Registered aircraft · 85,612

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.

N29CWHamilton Aerospace LLC · Lovettsville, VAS/N 34-7570306N29DAJones David W · Carlisle, PABuilt 1975 · S/N TH-645N29DCDwlg Aviation LLC · Rogers, ARBuilt 1965 · S/N D-7943N29DLCrouch David T · Asheville, NCBuilt 1976 · S/N E-913N29DMTimberlake Abigail · Eagle, COS/N 28-10812N29EALorimor Thomas T · Sidney, IABuilt 1976 · S/N CE622N29ERCosta Air Service LLC · Painted Post, NYBuilt 1977 · S/N 17269532N29FBRegistered aircraftS/N 32-46051N29FCUsda Forest Service Fepp · Raleigh, NCBuilt 1968 · S/N U206-1191N29FLTorres Chris · Princeton, CABuilt 1968 · S/N 18258813N29FMJones Jonathan Paul · Pinehurst, NCBuilt 1997 · S/N 24-3406N29FZTrn Aviation LLC · Mcallen, TXBuilt 1977 · S/N 28R7703052N29HCInternational Air Services Inc Trustee · Carson City, NVS/N 3449073N29HLSchreiber Christopher · Foley, ALBuilt 1975 · S/N 17266262N29HPRusso Kevin J · North Branch, NJBuilt 1976 · S/N E-831N29JFJkg LLC · Murfreesboro, TNBuilt 1968 · S/N 18259450N29KMDebonair Consulting Inc · Wilmington, DEBuilt 1955 · S/N 31579N29LCareer Flyers LLC · Crittenden, KYBuilt 1966 · S/N 28-22418N29MFChas N Clark Associates Ltd · Laurel, MSBuilt 2000 · S/N TH-1966N29MXPeterson Jim · Bedford, WYBuilt 1975 · S/N 17266309N29NAGula Jason · Scranton, PABuilt 1969 · S/N 28-26246N29NCBeasley Fred Scott · Tulsa, OKBuilt 1967 · S/N 28-4277N29PCFisher Douglas C · Mountain View, CABuilt 1979 · S/N 18266929N29PMAlly Mohamed Yacoob · Fort Lauderdale, FLS/N U20605769N29RBAdvantage Aviation Services LLC · South Saint Paul, MNS/N TD-174N29RFCaldwell Rob · Danville, KYBuilt 1979 · S/N E-1445N29RKRhk Of Kansas Inc · Jefferson City, MOBuilt 1982 · S/N TC-2451N29RMRedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1975 · S/N 28R-7535269N29RRKhg Aviation Holdings LLC · Columbus, OHBuilt 1982 · S/N TJ-414N29SCBrown Sherrie C · Cushing, OKBuilt 1962 · S/N 24-3125N29SDRegistered aircraftBuilt 1968 · S/N 28R-30583N29SPPurpera Daryl G · Pride, LAS/N 28R-35695N29SRAviation USA LLC · Anchorage, AKBuilt 1978 · S/N 18503582N29TCBeach Bonanza LLC · Shreveport, LABuilt 1991 · S/N E-2644N29TEBessarab Alex · Portland, ORBuilt 1979 · S/N 28-7916397N29TLTml Aircraft Inc · Narrowsburg, NYBuilt 1976 · S/N 28-7615248N29VRegistered aircraftBuilt 1972 · S/N D-9340N29WC29wc Inc · Malta, NYS/N E-1642N29YPeters Duane A · Anchorage, AKS/N EH-16N2ABBailey Richard T · Oregon City, ORBuilt 1960 · S/N 24-1941N2AJBlair Aviation LLC · Swamp Branch, KYFirst renewal noticeBuilt 1981 · S/N R18201789N2AMFazio Peter A · Nokomis, FLBuilt 1977 · S/N 24-0156N2BBLowry Air LLC · Tahlequah, OKBuilt 1972 · S/N TC-1447N2BLInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 25-0104N2BYMostello Andrew · Harvard, MABuilt 1977 · S/N 28R-7737129N2CBBoxman LLC · Wilmington, DEBuilt 1977 · S/N D-10090N2CLSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 28R-8131054N2CNCassel Paul E · Hernando, MSS/N 18052848N2CSBolton Geoffrey M · Groveland, CABuilt 1973 · S/N D-9463N2CWMiller Steven D · Mccall, IDS/N 18502486
Back to AD 98-21-21 R1