AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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.
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:2007-04-19-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:2007-04-19-R1') 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.
N4470YAmundson Daryl A · Blue Earth, MNN4470ZRegistration Pending · Weatherford, TXRegistration pendingN44710Bonin David P · Belmond, IAN44714Burchfield Bill · Tanner, ALN44715Skogen Karl L · White Bear Lake, MNN4471EWolfe John · Marathon, FLN4471JN4471j LLC · Dover, DEFirst renewal noticeN4471NSpitzer Helicopter LLC · Wilmington, DEN4471RMurray Carol A · Hilo, HIN4471ZEgolf Charles F · Spokane, WAN4472DSky Helicopters Inc · Desoto, TXN4472FA&J Aircraft Leasing Inc · Burlington, CON4472HSalamon Uri · Boerne, TXN4472MStone Aviation Enterprises Inc · East Syracuse, NYN4472RFlyrite Aviation LLC · Fort Myers, FLN4472YSilent Flight LLC · Payette, IDN4473FPate Elaine · Thousand Oaks, CAN4473JAj Aviation LLC · Gwinner, NDN4473PSemeniuk Steven T · Houston, TXN4473RMiller Keith A · Reedy, WVN4473XSlipstream Aviation LLC · Calera, ALN4473ZEriksen Rodney B Trustee · Juneau, AKN44747Goldenburg Timothy A · Ypsilanti, MIN44749Hoprich Jeffrey S · Roanoke, VAN4474FN44107 LLC · Marlton, NJN4474MN4474m Inc · Camarillo, CAN4474STailwind Aviation LLC · New Rochelle, NYN4474WR And S Aviation LLC · Corning, ARN4474XToledo City School District · Swanton, OHN4474ZWatts Craig W · Incline Village, NVN44753Registration Pending · Torrance, CARegistration pendingN44754Greenville Pickens Roundtrac LLC · Easley, SCN4475ARyan Justin M Jr · Rch Palos Vrd, CAN4475JHilburn Brian · Philadephia, PAN4475PRamaswamy Gautam · Clearwater, FLN4475RBrown Charles A · Portland, TXN4475TWings Over Texas Holdings LLC · Denton, TXN44761Henderson Gregory S · Saltsburg, PAN44763Flying Peanuts LLC · Wilmington, DEN44764Hess Alex · American Fork, UTN4476VDirty Bird Helicopters LLC · Boerne, TXN4476WBmg Aviation Leasing LLC · Bloomington, INN4476ZS And C Flying LLC · Pierre, SDN44771Benedict Kevin M · Lakeland, FLN44772Hanson Donald H · Bellevue, WAN44773Nair Vihas G · Philadelphia, PAN44775Heuerman Jordan D · Casey, ILN44777Delisi Carl V · Linden, MIN4477ABrown Danny J · Skidmore, MON4477PAirknocker Inc · Wilmington, DE
Back to AD 2007-04-19 R1