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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N1300TVarnado Calvin M · Palmer, AKN13019Plumer Eric · The Plains, VAN1302GDarby Patricia Petosky · Midland, TXN1302QProfessional Pilot Training Inc · Eagle Lake, TXN13030Miller Tim D · Seymour, MON1303QMontemayor Joshua Lee · Orlando, FLN1304MBourg Frederick I · Drummond, WIN1305FShlapak Jeffrey M · Peachtree City, GAN1305QThomas George E · Marietta, OHN13061Kelly Thomas E · Tequesta, FLN1306QCompton Kenneth Dale · Mebane, NCN1307GPray Aviation Inc · Augusta, KSN13084Lutz Kelly L · Auburndale, FLN1308UCarson Danny L · Oneida, TNN1309QSteenbarger Summer D · Woodland, WAN130HJJaynes Grayson V · Burnet, TXN130RVUddin Nazim · Buffalo, NYN13108Registered aircraftN1310FHumphries Aviation LLC · Maysville, KYN13128Huffman David L · Corsicana, TXN1312FBill Stephan · Ellenville, NYN1314FLee James Christopher · Concord, GAN1315FApsey Bradley D · Deckerville, MIN1315QWhite Beth A · Keene, NHN13180Skyward Fleet Solutions LLC · Granite Bay, CAN1319QOutman Christopher · Lowell, MIN1322QMadden Killian · Worcester, MAN1324FWyllie Ashton R J Trustee · Thornton, NHN1326FRegistration Pending · Heber Springs, ARRegistration pendingN1326QFreburg Larry D · Omaha, NEN1327FSwepston Nicole S · Jackson, OHN13282Cook Thomas H · Harbor Springs, MIN13285Royalty Flight Solutions LLC · West Babylon, NYN1328FSaindon Christopher M · Orlando, FLN132SMBartholet John C · Columbus, GAN13305Harbin Michael Wade · Monahans, TXN13307Burden Richard M Trustee · Woodway, TXN13314Egan Richard G · Tallahassee, FLN1331FKing James H · Barneveld, NYN1332QMcgrath Robert B · Haiku, HIN1333MJil Aviation Inc · La Coste, TXN1333TWoodford Michael F · Fabius, NYN13342Aog Hawaii LLC · Paia, HIN1334FHamilton Alathea L · Frankfort, KYN1335QStaley Julie M · Juneau, AKN13362Edwards Samuel T · Mustang, OKN1336FNelson David E · Windsor, VAN13379Gittleson Vernon H · Franklin Grove, ILN1337QSegars Alvin John · Austin, TXN1338FVogel Auto Repair LLC · Palmer, NE
Back to AD 72-03-03 R3