AD 2018-17-01
Registered aircraft · 147
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-17-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-17-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-17-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-17-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.
N288DLTvpx Ars Inc Trustee · North Salt Lake, UTN28VAVirginia State Police · Richmond, VAN300SJBell Textron Inc · Fort Worth, TXN303VSVertol Systems Company Inc · Destin, FLN306SBSan Bernardiino County Sheriffs Dept · San Bernardino, CAN307SBSan Bernardino County Sheriffs Aviation Division · San Bernardino, CAN308SBSan Bernardino County Sheriffs Dept · San Bernardino, CAN310MPSuperior Aviation Solutions LLC · Mooresville, NCN316LHLohman Helicopter LLC · Lewiston, IDN34JJWestern USA Solutions Inc · Kodiak, AKN359EHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN366MRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN369ECEcolift Corp · San Juan, PRN373PACopter Lease LLC Trustee · Albuquerque, NMN374PACopter Lease LLC Trustee · Albuquerque, NMN376PAPathfinder Leasing LLC · Anchorage, AKN377AFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN378PACopter Lease LLC Trustee · Albuquerque, NMN390BTBell Textron Inc · Fort Worth, TXN391BMBell Textron Inc · Fort Worth, TXN391TCBell Textron Inc · Fort Worth, TXN391TMBell Textron Inc · Fort Worth, TXN395BHBell Textron Inc · Fort Worth, TXN395BTBell Textron Inc · Fort Worth, TXN397ALVertol Systems Co LLC · Wilmington, DEN401TLTurbines Ltd · West Point, NEN402ESNorth Slope Borough · Barrow, AKN402TLFlorida State Guard · Tallahassee, FLN409KCKern County Fire Department · Bakersfield, CAN40VACommonwealth Of Virgina Dept Of State Police · Richmond, VAN411DEU S Department Of Energy · Las Vegas, NVN412ACBank Of Utah Trustee · Salt Lake City, UTN412ADGeorgia Dept Of Public Safety · Kennesaw, GAN412ESAspen Helicopters Inc · Oxnard, CAN412ETEurotec Vertical Flight Solutions LLC · Eudora, KSN412EXBell Textron Inc · Fort Worth, TXN412FCity Of Houston · Houston, TXN412TXBernailillo County Sheriffs Office · Albuquerque, NMN412VCCounty Of Ventura Sheriffs Office · Camarillo, CAN412WPSalt River Project · Phoenix, AZN417ACBank Of Utah Trustee · Salt Lake City, UTN41VSVertol Systems Co Inc · Destin, FLN4359FPetroleum Helicopter Technology Inc · San Antonio, TXN470QLVertol Systems Co Inc · Destin, FLN500EHHilcorp Equipment LLC · Anchorage, AKN508EHHilcorp Equipment LLC · Anchorage, AKN512PAPatriot Aviation Inc · Greenville, DEN515Savauge Air LLC · North Las Vegas, NVN530NCCopter Lease LLC Trustee · Albuquerque, NMN533NCStraight Up Leasing Inc · Medford, OR
Back to AD 2018-17-01