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.
N313RXReach Air Medical Services LLC · Santa Rosa, CAN314PHPhi Health LLC · Tempe, AZN314RXReach Air Medical Services LLC · Santa Rosa, CAN315MFQuad City Helicopter Emergency Medical Service · Davenport, IAN315RXAir Evac Ems Inc · O Fallon, MON316RXReach Air Medical Services LLC · Santa Rosa, CAN317PHPhi Health LLC · Tempe, AZN317RXReach Air Medical Services LLC · Santa Rosa, CAN317VUVanderbilt University Medical Center · Nashville, TNN318RXReach Air Medical Services LLC · Santa Rosa, CAN319RXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN31RXReach Air Medical Services LLC · Santa Rosa, CAN320PHPhi Health LLC · Tempe, AZN320TVBristow LLC · Lake Charles, LAN321LNAir Methods LLC · Greenwood Village, CON321RXReach Air Medical Services LLC · Santa Rosa, CAN322RXReach Air Medical Services LLC · Mcclellan, CAN323PHPhi Health LLC · Tempe, AZN323RXReach Air Medical Services LLC · Santa Rosa, CAN324PHPhi Health LLC · Tempe, AZN324RXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN324XMBristow LLC · Lake Charles, LAN325DBBristow LLC · Lake Charles, LAN325PHPhi Health LLC · Tempe, AZFirst renewal noticeN325RXReach Air Medical Services LLC · Santa Rosa, CAN326PHPhi Health LLC · Tempe, AZN326RXReach Air Medical Services LLC · Santa Rosa, CAN327PHPhi Health LLC · Tempe, AZN328PHPhi Health LLC · Tempe, AZN328RXReach Air Medical Services LLC · Santa Rosa, CAN329PHPhi Health LLC · Tempe, AZN329RXReach Air Medical Services LLC · Santa Rosa, CAN330PHPhi Health LLC · Tempe, AZN332PHPhi Health LLC · Tempe, AZN335DHMary Hitchcock Memorial Hospital · Lebanon, NHN335MLMercy Hospital Springfield · Springfield, MON337PHPhi Health LLC · Tempe, AZN344PHPhi Health LLC · Tempe, AZN347MTNorth Shore-Lij And Yale New Haven Health Medical · Great Neck, NYN348MHMaritime Helicopters · Homer, AKN356AMAirbus Helicopters Inc · Grand Prairie, TXN356MPAltair Helicopter Service LLC · Marshfield, MAN362AHCharlotte Mecklenburg Hospital Authority · Charlotte, NCN362GRAirbus Helicopters Inc · Grand Prairie, TXN363AHCharlotte Mecklenburg Hospital Authority · Charlotte, NCN363GRAirbus Helicopters Inc · Grand Prairie, TXN364GRAirbus Helicopters Inc · Grand Prairie, TXN365GRAirbus Helicopters Inc · Grand Prairie, TXN366AHCharlotte Mecklenburg Hospital Authority · Charlotte, NCN366GRAirbus Helicopters Inc · Grand Prairie, TX
Back to AD 2018-07-01