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.

N149RBest Erectors Inc · Wilmington, DEBuilt 1978 · S/N D-10161N149WLCarter Robert J Jr · Oak Ridge, TNS/N E3562N14AJChalk 2 Inc · Apple Valley, CABuilt 1980 · S/N TH-1154N14APGlobal Air Concepts LLC · Anchorage, AKBuilt 1977 · S/N 31-7752060N14ARRatliff Alvin · Northport, ALBuilt 1975 · S/N CE-561N14AZD & L Aircraft Leasing LLC · Ormond Beach, FLBuilt 1975 · S/N 17263495N14BABurris & Macomber P L L C Trustee · Tucson, AZS/N 18261211N14BEBelmont Circle LLC · Virginia Beach, VABuilt 1979 · S/N 28-7911322N14BLEagle Equity Inc · Valparaiso, INBuilt 1968 · S/N 17257735N14BRGobin Albert W · Crawfordsville, INS/N 310K0104N14CEFacility Concepts Developments LLC · Jackson, MSBuilt 1989 · S/N TH-1562N14CMGallagher Michael S · Los Alamitos, CABuilt 1971 · S/N D-9298N14CPWheels Floats Skids And Skis LLC · Brooklyn, MIS/N 19721N14DADonaire Aviation LLC · Tampa, FLBuilt 1962 · S/N TD-505N14DFCook Charles M · Jay, FLBuilt 1957 · S/N D-5336N14DJJ&N Management Inc · Wilmington, DEBuilt 2001 · S/N 2843497N14DP5b Aviation LLC · Duncan, OKBuilt 1970 · S/N 28-5738N14DWBurnett Timothy S · Birmingham, ALS/N 32R-7887023N14FCJwc59 LLC · Newnan, GABuilt 1959 · S/N 24-924N14FMDurbin Gregory M · Dallas, TXS/N D-7802N14FPBakowicz John R · Sunbury, PABuilt 1974 · S/N 34-7450096N14FZWurzer Frank · Tallmadge, OHBuilt 1978 · S/N 34-7870122N14GSAirrich LLC · Largo, FLBuilt 1971 · S/N 27-4637N14JEN14je LLC · White Springs, FLBuilt 1975 · S/N 21060792N14JHRegistered aircraftBuilt 1998 · S/N TH-1845N14JMMckinstry Aviation LLC · Parker, COBuilt 1974 · S/N 18052475N14JNNational Test Pilot School · Mojave, CABuilt 1975 · S/N 34-7570254N14JPDakota Aircraft Inc · Pierre, SDBuilt 1986 · S/N CJ-177N14KCAviation Engineering Technical Services Inc · Savannah, GABuilt 1979 · S/N 28R-7931082N14KMRiver City Aero Club Inc · Columbus, GABuilt 1965 · S/N 17254062N14LNSchultz Tim J · Mount Juliet, TNBuilt 1971 · S/N 28-7225043N14LRGolly Laura · Deridder, LABuilt 1974 · S/N E-524N14LVSmetana Louis V III · Blair, NEBuilt 1970 · S/N 21059259N14MBJackson Craig D · Idaho Falls, IDBuilt 1977 · S/N E-1062N14MCBlue Skies Blue Water LLC · Henderson, NVBuilt 1964 · S/N 320C0008N14MDDaniel Development LLC · Durango, COBuilt 1962 · S/N 18254114N14MNOne Room LLC · Abilene, TXBuilt 1978 · S/N E-1344N14MTSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N R18201227N14NFStiles Terry D · King Salmon, AKBuilt 1968 · S/N 17256844N14NNAms Aviation LLC · South Bend, INBuilt 1980 · S/N U20605374N14NRPiper Capital Investments LLC · Denton, TXBuilt 1965 · S/N 28-20614N14PGorman Aviation LLC · Bartlesville, OKBuilt 1985 · S/N TJ-492N14PHHuman Lee · Mercer Island, WABuilt 1981 · S/N 18504323N14PLByers Steven · San Diego, CABuilt 1966 · S/N 18051711N14PZDivinia Dustin · Bonham, TXS/N 28-11050N14RFBerry Darrel · Camden, TNBuilt 1973 · S/N E-486N14RWJohnston Jeffrey T · Ramsey, MNS/N 28-10217N14SFArnold Kiefer · East Prairie, MOBuilt 1973 · S/N 74-32-131N14SSBas Part Sales LLC · Greeley, COS/N 34-7770385N14TWAllbid Inc · Opelousas, LAS/N 670148
Back to AD 98-21-21 R1