AD 72-03-03 R3
Registered aircraft · 17,027
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.
N61253Flight Gate LLC · Wilton, CAN61259Lund Michael J · Poulsbo, WAN6125FParker Richard A · West Chicago, ILN6126FCarson John D · Garber, OKN6126RKelley Kal · Colville, WAN6127FSmith Phillip · Osprey, FLN6127RPhillips Bill · Galt, CAN61282Trimble David G · Vici, OKN61286Houseman Jeffery D · Millersville, MON61288Vanorman Curt M · Clarkesville, GAN6128ROhop Robert D · Jones, OKN61296Coomes Scott F · Seattle, WAN61297Highway Jet League Flyers Brotherhood LLC · Allouez, WIN6129GPeters William E · Bel Air, MDN6129RIncline Engineering And Consulting LLC · Ovalo, TXN612DMRegistered aircraftN612HKDickey Stephen H · De Leon, TXN6130FBas Part Sales LLC · Greeley, CON6130RHarris Phillip S · Greenwood Village, CON61311Wood James A · Madera, CAN6131FLundell Brandon M · Lyons, CON6131GCragg Gordon E · Georgetown, TXN6131RAir LLC · Salem, ORN61321Gerdes Brian K · Los Alamitos, CAN61324Wills Evan J · Lynnwood, WAN61325Zetir Mohamad · Oviedo, FLN61329Girls Love To Fly Inc · Roseville, CAN61333Gustafson Michael J · Minnetonka, MNN61336Evans David C · Thousand Oaks, CAN61338Flyit LLC · Camas, WAN61345Carlson Brent A · Shelley, IDN61354New Vision Aviation · Fresno, CAN6135FJr Imaging Logistics Inc · Pasco, WAN61363Hulbert Stephen R · Fort Ransom, NDN61365Plane Progress LLC · Waterloo, IAN6137FWingland Inc · Los Angeles, CAN6137GPiersol Benjamin T · Honey Brook, PAN6138FSchlegelmilch Scott A · Elkhorn, NEN6138GStrange Keith · Lincoln, MEN613WDCruse Josiah L · Rainier, ORN6140FFluno John I · San Rafael, CAN6140GSmoketown Flight Center LLC · Smoketown, PAN6143GSale Reported · Brodhead, WISale reportedN6144GHoke Christopher R · Kernersville, NCN6145FAlpha Bravo Aviation LLC · Trophy Club, TXN6146FHeppner Sebastian · Fishers, INN6147FHenry Charles C · Portland, TNN6148FWorsham Eric S · La Porte, TXN6150GStockton Raymond L · Pearl City, HIN6151RPath Barney H DBA · Claremont, CA
Back to AD 72-03-03 R3