AD 2016-18-18
Registered aircraft · 146
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:2016-18-18')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-18-18')
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:2016-18-18') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-18-18') 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.
N716LPTurbines Ltd · West Point, NEN71NMNorth Memorial Health Care · Brooklyn Center, MNN7242NMaverick Jet Leasing Inc · Wilmington, DEN72HRSeminole Tribe Of Florida DBA · Davie, FLN731HCIntermountain Medical Transport LLC · Salt Lake City, UTN737PGGlobal Aircraft Trust Inc Trustee · Cheyenne, WYN73AZTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN745HAPrivate LLC · Kalispell, MTRegistration ineffective or invalidN749SDRocklyn 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 pendingN800WKDiamond Helicopters LLC · Los Angeles, CAFirst renewal noticeN80NYWgb 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, CAN876RJTre Aviation Corp · Wilmington, DEN890PAAgustawestland Philadelphia Corp · Philadelphia, PANon-citizen corporation, flight hours not reportedN897BCIntersouth Inc · Santo DomingoN8UFIntegrity Aircraft Title Holdings LLC · Portland, ORN901CMLifeflight Of Maine LLC · Bangor, MEN901EMLifeflight Of Maine LLC · Bangor, MEN901HCIhc Health Services Inc DBA · Salt Lake City, UTN901LFLifeflight 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, OHN921LFLife Flight Network LLC · Aurora, ORN922LFEurotec Vertical Flight Solutions LLC · Eudora, KSN923LFEurotec Vertical Flight Solutions LLC · Eudora, KSN92LFEurotec Vertical Flight Solutions LLC · Eudora, KSN94AHEurotec Vertical Flight Solutions LLC · Eudora, KSN95RZSt Vincent Mercy Medical Center · Toledo, OHN962JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN963JERegistered aircraftAssigned (import), pending cancellationN9CWGran Cosecha LLC · Lake Wales, FL
Back to AD 2016-18-18