AD 2018-07-17
Registered aircraft · 120
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:2018-07-17')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-07-17')
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:2018-07-17') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-07-17') 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.
N534MECenter For Emergency Medicine Of Western Pa · West Mifflin, PAN536MECenter For Emergency Medicine Of Western Pa · West Mifflin, PAN537MECenter For Emergency Medicine Of Western Pennsylva · West Mifflin, PAN544MECenter For Emergency Medicine Of Western Pa · West Mifflin, PAN549AMAir Methods LLC · Greenwood Village, CON552TJAir Methods LLC · Greenwood Village, CON576MECenter For Emergency Medicine Of Western Pennsylva · West Mifflin, PAN579AMAir Methods LLC · Greenwood Village, CON579MECenter For Emergency Medicine Of Western Penn · West Mifflin, PAN589MECenter For Emerg Med Of W Penn Stat Medevac Prog · West Mifflin, PAN590MECenter For Emergency Medicine Of Western Pa · West Mifflin, PAN60ZXTonik Air LLC · Las Vegas, NVN620MECenter For Emergency Medicine Of Western Pa · West Mifflin, PAN635WVanderbilt University Medical Center · Nashville, TNN641MECtr For Emergency Medicine Of Western Pennsylvania · West Mifflin, PAN691CMG200 LLC · San Juan, PRN735VTRegistered aircraftN740MHMetro Aviation Inc · Shreveport, LAN775TCUS Department Of Homeland Security · Washington, DCN802MHWorld Trade Enterprises LLC · Lucas, TXN811MECenter For Emergency Medicine Of Western Pa · West Mifflin, PAN81LNAir Methods LLC · Greenwood Village, CON822PPMassachusetts State Police · Plymouth, MAN823JMMassachusetts State Police · Plymouth, MAN824AHMassachusetts State Police · Plymouth, MAN825MMMassachusetts State Police · Plymouth, MAN831MEAir Methods LLC · Greenwood Village, CON845BPUS Department Of Homeland Security · Washington, DCN845MECenter For Emergency Medicine Of Western Pa · West Mifflin, PAN846BPUS Department Of Homeland Security · Washington, DCN855MECenter For Emergency Medicine Of Western Pa · West Mifflin, PAN856BPUS Department Of Homeland Security · Washington, DCN863NCAir Methods LLC · Greenwood Village, CON864NCAir Methods LLC · Greenwood Village, CON865CHAir Methods LLC · Greenwood Village, CON877CRAir Methods LLC · Greenwood Village, CON884MELta Group Holdings LLC · Amarillo, TXN891TTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN892TTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN89EMIntegra Aviation LLC · Amarillo, TXN905VUVanderbilt University Medical Center · Nashville, TNN906VUVanderbilt University Medical Center · Nashville, TNN908ACAir Methods LLC · Greenwood Village, CON908VUVanderbilt University Medical Center · Nashville, TNN911AXGuardian Flight Holdings Inc · Fairbanks, AKN911CBCollier County Emergency Medical Service · Naples, FLN911RZAir Med Services LLC · Lafayette, LAN911UGAir Methods LLC · Greenwood Village, CON911XAAir Med Services LLC · Lafayette, LAN911XBAir Med Services LLC · Lafayette, LA
Back to AD 2018-07-17