AD 2018-16-08
Registered aircraft · 109
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-16-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-16-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-16-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-16-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.
N45BZLogistics Business Services LLC · Cheshire, CTN45SHSunflower Aviation LLC · Greenleaf, KSN48SHIndiana Helicopters LLC · Fort Wayne, INN508CFAerotrust Services Corp Trustee · Wilmington, DEN50BReina Capital II LLC · Miami, FLN517QAAltus Aviation Management · Las Vegas, NVN530KSBristow LLC · Lake Charles, LAN531HCIntermountain Medical Transport LLC · Salt Lake City, UTN567HBCj Leasing LLC Trustee · Lakeland, FLN57HRSeminole Tribe Of Florida DBA · Davie, FLN59PDiesel Acquisitions LLC · Milpitas, CAN59ZXAs 355 LLC · Gay, GAN5UVPortlock Aviation LLC · Mansfield, TXN613HAHa 109e LLC · Flushing, NYN618HRBoardwalk Air I LLC · Atlantic City, NJN621SCSouth Bay Helicopter Service Inc · Hayward, CAN631HCIntermountain Medical Transport LLC · Salt Lake City, UTN65CJBank Of Utah Trustee · Salt Lake City, UTN68NMNorth Memorial Healthcare · Brooklyn Center, MNN69KGBank Of Utah Owner Trustee · Salt Lake City, UTN6JEEurotec Vertical Flight Solutions LLC · Eudora, KSN6VZLeonardo Helicopters US Corp · Philadelphia, PAN71NMNorth Memorial Health Care · Brooklyn Center, MNN72HRSeminole Tribe Of Florida DBA · Davie, FLN731HCIntermountain Medical Transport LLC · Salt Lake City, UTN73AZTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN749SDRocklyn Leasing LLC · Duluth, GAN75GGA109s LLC · Pinecrest, FLN770PATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN786MKAviation Trust Co LLC Trustee · Oklahoma City, OKN789RTIntegrity Aircraft Title Holdings LLC · Portland, ORN7ADEurotec Vertical Flight Solutions LLC · Eudora, KSN7UCRegistration Pending · Greenwood Village, CORegistration pendingN80NYWgb Holdings LLC · Sparta, NJN814WFRed Hawk Management LLC · Ocilla, GAN81NMNorth Memorial Health Care · Brooklyn Center, MNN820FTBristow LLC · Lake Charles, LAN827KUEurotec Vertical Flight Solutions LLC · Eudora, KSN85KVKhosla Ventures LLC · San Jose, CAN890PAAgustawestland Philadelphia Corp · Philadelphia, PANon-citizen corporation, flight hours not reportedN901CMLifeflight Of Maine LLC · Bangor, MEN901EMLifeflight Of Maine LLC · Bangor, MEN901LFLifeflight Of Maine LLC · Bangor, MEN901WMLifeflight Of Maine · Bangor, MEN901XMLifeflight Of Maine LLC · Bangor, MEN901YMLifeflight Of Maine LLC · Bangor, MEN90NMNorth Memorial Health Care · Minneapolis, MNN910LBBristow LLC · Lake Charles, LAN91LFInternational Defense & Aerospace Group LLC · Glen Mills, PAN91SVSaint Vincent Mercy Medical Center · Toledo, OH
Back to AD 2018-16-08