AD 2018-07-08
Registered aircraft · 310
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-08')
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-08')
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-08') 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-08') 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.
N291HCIntermountain Medical Transport LLC · Salt Lake City, UTN298RN962heli LLC · Edmond, OKN2ENEurotec Vertical Flight Solutions LLC · Eudora, KSN306LGMed-Trans Corp · Denton, TXN30EHHelinet Aviation Services LLC · Van Nuys, CAN30GKAircraft Partner Holdings Inc Trustee · Fallbrook, CAN316PDLonghorn Air LLC · Wilmington, DEN319MCMercy Flight Central Holding LLC · Canandaigua, NYN319PDOrtiz Luis Emerito Nieves · Plantersville, TXN32NGBest Aircraft Deals LLC · Salt Lake City, UTN330JNBristow LLC · Lake Charles, LAN334JTBristow LLC · Lake Charles, LAN351LLCritical Care Services Inc DBA · Blaine, MNN352LLCritical Care Services Inc DBA · Blaine, MNN353LLCritical Care Services Inc DBA · Blaine, MNN354LLCritical Care Services Inc DBA · Blaine, MNN355LLCritical Care Services Inc DBA · Blaine, MNN356LLCritical Care Services Inc DBA · Blaine, MNN357LLCritical Care Services Inc DBA · Blaine Gton, MNN358LLCritical Care Services Inc DBA · Blaine, MNN359LLCritical Care Services Inc DBA · Blaine, MNN35NMNorth Memorial Health Care · Brooklyn Center, MNN360LLCritical Care Services Inc DBA · Blaine, MNN362CRU S Bank Equipment Finance Division · Marshall, MNN365AARegistration Pending · Greenwood Village, CORegistration pendingN365LLCritical Care Services Inc DBA · Blaine, MNN367LLCritical Care Services Inc DBA · Blaine, MNN368LLCritical Care Services Inc DBA · Blaine, MNN385RTIntegrity Aircraft Title Holdings LLC · Portland, ORN418CPEurotec Vertical Flight Solutions LLC · Eudora, KSN42KMKhm Holdings LLC · Winnabow, NCN42NMNorth Memorial Health Care · Brooklyn Center, MNN431HCUS Bank Na · Marshall, MNN433AKHelinet Aviation Services LLC · Van Nuys, CAN435AKHelinet Aviation Services LLC · Van Nuys, CAN449CTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN45BZLogistics Business Services LLC · Cheshire, CTN45SHSunflower Aviation LLC · Greenleaf, KSN48SHIndiana Helicopters LLC · Fort Wayne, INN508CFAerotrust Services Corp Trustee · Wilmington, DEN50BReina Capital II LLC · Miami, FLN516LFBank Of Utah Trustee · Salt Lake City, UTN517QAAltus Aviation Management · Las Vegas, NVN530KSBristow LLC · Lake Charles, LAN531HCIntermountain Medical Transport LLC · Salt Lake City, UTN546LFBank Of Utah Trustee · Salt Lake City, UTN556LFWilmington Trust Co Trustee · Wilmington, DEN566LFWilmington Trust Co Trustee · Wilmington, DEN567HBCj Leasing LLC Trustee · Lakeland, FLN57HRSeminole Tribe Of Florida DBA · Davie, FL
Back to AD 2018-07-08