OpenAirDocs.org
AD 73-21-01

Registered aircraft · 3,214

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:73-21-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:73-21-01')
  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.

N100TEBlaney Robert L · Newark, OHBuilt 1975 · S/N 22-1255N1015EBrown Richard T · Anaheim, CABuilt 1965 · S/N 255N101TLojek Donald W · Boise, IDBuilt 1964 · S/N 2887N103PTAvion Guy LLC · Baton Rouge, LABuilt 1975 · S/N 22-1252N1046BOglesby Jonathan D · Okmulgee, OKBuilt 1958 · S/N 1273N104PBMountain Flight LLC · Missoula, MTBuilt 1974 · S/N 20-0035N1063BFlat Earth LLC · Kalispell, MTBuilt 1958 · S/N 1290N1066CGullett Steve L · Bethel, OHBuilt 1958 · S/N 1337N1073BPickering Michael A · Walpole, NHS/N 1300N1077CMckinney Jonathan C · Oviedo, FLS/N 1348N1089BDakota Territory Air Museum Inc · Minot, NDBuilt 1958 · S/N 1315N1091CReif James D · East Lansing, MIBuilt 1959 · S/N 1362N1095BReinschmidt John S · Austin, TXBuilt 1958 · S/N 1321N1099CBrooks Jerald W · Anderson, CABuilt 1959 · S/N 1370N10ADTeerlink Randall S · Hanover, VABuilt 1976 · S/N 20-1221N10CHGulf Coast Rail Service Inc · Victoria, TXBuilt 1969 · S/N 690048N10HVRegistered aircraftBuilt 1965 · S/N 715N10YMDanhauer Christopher W · Marshall, TXBuilt 1961 · S/N 1753N111MJJohn D Chinchen Md Pa · Mountain Home, ARBuilt 1968 · S/N 680147N112PHRegistered aircraftBuilt 1967 · S/N 670466N1133XBristol Aircraft Leasing LLC · Willoughby, OHBuilt 1967 · S/N 670504N117RWAli Mohammad Usman · Fort Worth, TXBuilt 1962 · S/N 2014N118RCAscent Aviation LLC · Lander, WYBuilt 1966 · S/N 670036N119LMRegistered aircraftBuilt 1971 · S/N 22-0001N11RYMsk Air Transport LLC · Mankato, MNBuilt 1965 · S/N 3173N1200XLacola Joseph D · Commerce Township, MIBuilt 1963 · S/N 103N1201XSimmons Herbert H Trustee · Pasadena, CABuilt 1963 · S/N 2604N1202XBrady Creative Services LLC · Forsyth, MOBuilt 1963 · S/N 2605N1203XMcelwain Russell D · Lancaster, KSBuilt 1963 · S/N 2606N1204XMcdonald Monroe · Aguila, AZBuilt 1963 · S/N 2607N1205XOsborn Aviation LLC · Claude, TXBuilt 1963 · S/N 183N1206XNlw 1 LLC · Washington, UTS/N 184N1208XCartaya Lazaro C · Miami, FLBuilt 1963 · S/N 2611N1210XDowdy Joseph N · Blacksburg, VABuilt 1963 · S/N 185N1212XLogsdon Dale L · Alva, OKBuilt 1963 · S/N 2615N1214XCouch Troy L · Westcliffe, COBuilt 1963 · S/N 2617N1215XCella Joseph · Sewell, NJBuilt 1963 · S/N 2618N1217XRanger Aviation Enterprises Inc · San Angelo, TXBuilt 1963 · S/N 187N1218XSmith II Richard D · Luthersville, GABuilt 1963 · S/N 2621N121EConger Martin D · Pasco, WABuilt 1963 · S/N 173N121RLZaytsev Petr · Pflugerville, TXBuilt 1969 · S/N 690072N1220XBuilding Enclosure Institute Inc · Hallandale Beach, FLBuilt 1963 · S/N 191N1223XAirspeed Consulting LLC · Mounds, OKBuilt 1963 · S/N 194N1224XAlpha Aviation Mission Outreach Center Inc · Muskogee, OKBuilt 1963 · S/N 195N1225XSuda Inc · Lindsborg, KSBuilt 1963 · S/N 196N1227XVan Hoosen Ronald L · Goldsby, OKBuilt 1963 · S/N 198N1230XMarquez Christopher · Gaithersburg, MDBuilt 1963 · S/N 104N1231WMusa Adam · Princeton, NJBuilt 1967 · S/N 670099N1232WMilam David N · Hannibal, MOBuilt 1967 · S/N 670088N1234KLatiolais Travis · Breaux Bridge, LABuilt 1966 · S/N 995
Back to AD 73-21-01