AD 72-03-03 R3

Registered aircraft · 17,023

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

N1300TVarnado Calvin M · Palmer, AKBuilt 1965 · S/N 17253731N13019Plumer Eric · The Plains, VABuilt 1975 · S/N 17702395N1302GDarby Patricia Petosky · Midland, TXBuilt 1964 · S/N 18255562N1302QProfessional Pilot Training Inc · Eagle Lake, TXBuilt 1971 · S/N 15072602N13030Miller Tim D · Seymour, MOBuilt 1967 · S/N R1720239N1303QMontemayor Joshua Lee · Orlando, FLBuilt 1971 · S/N 15072603N1304MBourg Frederick I · Drummond, WIBuilt 1971 · S/N 15072604N1305FShlapak Jeffrey M · Peachtree City, GABuilt 1966 · S/N 17254800N1305QThomas George E · Marietta, OHBuilt 1971 · S/N 15072605N13061Kelly Thomas E · Tequesta, FLBuilt 1975 · S/N 17702396N1306QCompton Kenneth Dale · Mebane, NCS/N 15072606N1307GPray Aviation Inc · Augusta, KSBuilt 1966 · S/N 17254120N13084Lutz Kelly L · Auburndale, FLBuilt 1976 · S/N 17702397N1308UCarson Danny L · Oneida, TNBuilt 1966 · S/N 15065444N1309QSteenbarger Summer D · Woodland, WAS/N 15072609N130HJJaynes Grayson V · Burnet, TXS/N 15068617N130RVUddin Nazim · Buffalo, NYS/N 15072090N13108Registered aircraftBuilt 1976 · S/N 17702398N1310FHumphries Aviation LLC · Maysville, KYBuilt 1966 · S/N 17254805N13128Huffman David L · Corsicana, TXBuilt 1976 · S/N 17702400N1312FBill Stephan · Ellenville, NYBuilt 1966 · S/N 17254807N1314FLee James Christopher · Concord, GABuilt 1966 · S/N 17254809N1315FApsey Bradley D · Deckerville, MIBuilt 1966 · S/N 17254810N1315QWhite Beth A · Keene, NHBuilt 1971 · S/N 15072615N13180Skyward Fleet Solutions LLC · Granite Bay, CABuilt 1976 · S/N 17702402N1319QOutman Christopher · Lowell, MIBuilt 1971 · S/N 15072619N1322QMadden Killian · Worcester, MABuilt 1971 · S/N 15072622N1324FWyllie Ashton R J Trustee · Thornton, NHBuilt 1966 · S/N 17254819N1326FRegistration Pending · Heber Springs, ARRegistration pendingBuilt 1966 · S/N 17254821N1326QFreburg Larry D · Omaha, NEBuilt 1971 · S/N 15072626N1327FSwepston Nicole S · Jackson, OHS/N 17254822N13282Cook Thomas H · Harbor Springs, MIBuilt 1976 · S/N 17702406N13285Royalty Flight Solutions LLC · West Babylon, NYBuilt 1976 · S/N 17702407N1328FSaindon Christopher M · Orlando, FLBuilt 1966 · S/N 17254823N132SMBartholet John C · Columbus, GABuilt 1973 · S/N 17702045N13305Harbin Michael Wade · Monahans, TXBuilt 1976 · S/N 17702409N13307Burden Richard M Trustee · Woodway, TXBuilt 1976 · S/N 17702410N13314Egan Richard G · Tallahassee, FLBuilt 1976 · S/N 17702412N1331FKing James H · Barneveld, NYBuilt 1966 · S/N 17254826N1332QMcgrath Robert B · Haiku, HIBuilt 1971 · S/N 15072632N1333MJil Aviation Inc · La Coste, TXBuilt 1972 · S/N 17260573N1333TWoodford Michael F · Fabius, NYBuilt 1969 · S/N T210-59108N13342Aog Hawaii LLC · Paia, HIBuilt 1976 · S/N 17702414N1334FHamilton Alathea L · Frankfort, KYBuilt 1966 · S/N 17254829N1335QStaley Julie M · Juneau, AKBuilt 1971 · S/N 15072635N13362Edwards Samuel T · Mustang, OKBuilt 1976 · S/N 17702415N1336FNelson David E · Windsor, VABuilt 1966 · S/N 17254831N13379Gittleson Vernon H · Franklin Grove, ILBuilt 1976 · S/N 17702416N1337QSegars Alvin John · Austin, TXBuilt 1971 · S/N 15072637N1338FVogel Auto Repair LLC · Palmer, NEBuilt 1966 · S/N 17254833
Back to AD 72-03-03 R3