AD 2012-18-18
Registered aircraft · 400
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:2012-18-18')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-18-18')
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:2012-18-18') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-18-18') 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.
N790AMUS Department Of Homeland Security · Washington, DCN791AMUS Department Of Homeland Security · Washington, DCN792AMUS Department Of Homeland Security · Washington, DCN793AMUS Department Of Homeland Security · Washington, DCN794AMUS Department Of Homeland Security · Washington, DCN794PPhi Aviation LLC · Lafayette, LAN796AMUS Department Of Homeland Security · Washington, DCN797PPhi Health LLC · Tempe, AZN798PPhi Health LLC · Tempe, AZN7ZSRogue Mountain LLC · Whitefish, MTN801MHSunshine Helicopters Inc · Puunene, HIN804CPBaltimore County Government · Baltimore, MDN804PAPathfinder Leasing LLC · Anchorage, AKN805BTBeta Fleet LLC · South Burlington, VTN805LFAir Methods LLC · Greenwood Village, CON805MHAirstar Leasing LLC · Henderson, NVN806MHAirstar Leasing LLC · Henderson, NVN806MPNs Air Leasing LLC · Wilmington, DEN806PAPathfinder Leasing LLC · Anchorage, AKN807AMUS Department Of Homeland Security · Washington, DCN807LFAir Methods LLC · Greenwood Village, CON807MHAirstar Leasing LLC · Henderson, NVN807MLRio Bravo Helicopters Inc · Dover, DEN808CPBaltimore County Government · Baltimore, MDN808LFAir Methods LLC · Greenwood Village, CON808MHAirstar Leasing LLC · Henderson, NVN810CESouthern California Edison · Chino, CAN810LFAir Methods LLC · Greenwood Village, CON811HWMed-Trans Corp · Denton, TXN814SMAir Methods LLC · Greenwood Village, CON816CESouthern California Edison Co · Chino, CAN817CESouthern California Edison Co · Chino, CAN818HAHelinet Aviation Services LLC · Van Nuys, CAN821MHMustang Leasing LLC · Henderson, NVN821SSFly Safe LLC · Wilmington, DEN822MHMustang Leasing LLC · Henderson, NVN823MHMustang Leasing LLC · Henderson, NVN837GCMonarch Enterprises Inc · Kirkland, WAN844BPUS Department Of Homeland Security · Washington, DCN846MHMustang Leasing LLC · Henderson, NVN847BPUS Department Of Homeland Security · Washington, DCN847MHMustang Leasing LLC · Henderson, NVN848MHMustang Leasing LLC · Henderson, NVN849BPUS Department Of Homeland Security · Washington, DCN849MHMustang Leasing LLC · Henderson, NVN849PBArrow Aviation Co LLC · Broussard, LAN850BPUS Department Of Homeland Security · Washington, DCN850MHMustang Leasing LLC · Henderson, NVN851MHMustang Leasing LLC · Henderson, NVN852MHMustang Leasing LLC · Henderson, NV
Back to AD 2012-18-18