AD 2018-07-01
Registered aircraft · 346
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-01')
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-01')
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-01') 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-01') 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.
N530LNAir Methods LLC · Greenwood Village, CON530MECenter For Emergency Medicine Of Western Pa · West Mifflin, PAN531LNAir Methods LLC · Greenwood Village, COFirst renewal noticeN531MTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN533LCAir Methods LLC · Greenwood Village, CON533MECtr For Emergency Medicine Of Western Pennsylvania · West Mifflin, PAN534LNAir Methods LLC · Greenwood Village, CON534MECenter For Emergency Medicine Of Western Pa · West Mifflin, PAN535DETentacle Corp · Walnut Creek, CAN535LLMercy Hospital Springfield · Springfield, MON535LNAir Methods LLC · Greenwood Village, CON535MTMed-Trans Corp · Lewisville, TXN536MECenter 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, CON551HUAir Methods LLC · Greenwood Village, CON555YEReach Air Medical Services LLC · Santa Rosa, CAN556MEAirbus Helicopters Inc · Grand Prairie, TXN556MTMed Trans Corp · Denton, TXN558MTMed-Trans Corporation · Denton, TXN565MEAirbus Helicopters Inc · Grand Prairie, TXN576MECenter For Emergency Medicine Of Western Pennsylva · West Mifflin, PAN577MTMed-Trans Corporation · Denton, TXN579MECenter For Emergency Medicine Of Western Penn · West Mifflin, PAN586AMAir Methods LLC · Greenwood Village, CON586WHMetro Aviation Inc · Shreveport, LAN589MECenter For Emerg Med Of W Penn Stat Medevac Prog · West Mifflin, PAN590MECenter For Emergency Medicine Of Western Pa · West Mifflin, PAN599MSAir Med Services LLC · Lafayette, LAN600HNHealthnet Aeromedical Services Inc · Charleston, WVN601MTMed-Trans Corp · Denton, TXN602MTMed-Trans Corp · Denton, TXN603MTMed-Trans Corp · Denton, TXN608MTAirbus Helicopters Inc · Grand Prairie, TXN608WGsh Crows Nest LLC · Boston, MAN615BDDeckoff Stephen H · St Thomas, VIN615LFAir Methods LLC · Greenwood Village, COFirst renewal noticeN620MECenter For Emergency Medicine Of Western Pa · West Mifflin, PAN635DHMetro Aviation Inc · Shreveport, LAN640ECMetro Aviation Inc · Shreveport, LAN641ECMetro Aviation Inc · Shreveport, LAN641MECtr For Emergency Medicine Of Western Pennsylvania · West Mifflin, PAN652ACAirbus Helicopters Inc · Grand Prairie, TXN655DVMed-Trans Corp · Denton, TXN655JTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN665MTMed-Trans Corp · Denton, TXN691CMG200 LLC · San Juan, PRN714GEPolar Star Corp · Kalispell, MTN719LSMed Trans Corp · Denton, TX
Back to AD 2018-07-01