AD 2016-25-13
Registered aircraft · 1,086
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-25-13')
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-25-13')
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-25-13') 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-25-13') 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.
N800DAAirbus Helicopters Inc · Grand Prairie, TXN800KCFlying Nut LLC · Artesia, NMFirst renewal noticeN801CXSalt Lake City Mosquito Abatement District · Salt Lake City, UTN801MHSunshine Helicopters Inc · Puunene, HIN803CPBaltimore County Maryland · Middle River, MDN803SPma 1 LLC · Wilmington, DEN804CPBaltimore County Government · Baltimore, MDN804PAPathfinder Leasing LLC · Anchorage, AKN805BTBeta Fleet LLC · South Burlington, VTN805LFAir Methods LLC · Greenwood Village, CON805MHAirstar Leasing LLC · Henderson, NVN806MHAirstar Leasing LLC · Henderson, NVN806MPNs Air Leasing LLC · Wilmington, DEN806PAPathfinder Leasing LLC · Anchorage, AKN807AMUS Department Of Homeland Security · Washington, DCN807LFAir Methods LLC · Greenwood Village, CON807MHAirstar Leasing LLC · Henderson, NVN807MLRio Bravo Helicopters Inc · Dover, DEN808CPBaltimore County Government · Baltimore, MDN808LFAir Methods LLC · Greenwood Village, CON808MHAirstar Leasing LLC · Henderson, NVN80HVOuter Banks Holdings LLC · Santa Fe, NMN810CESouthern California Edison · Chino, CAN810HWMed-Trans Corp · Denton, TXN810LFAir Methods LLC · Greenwood Village, CON811HWMed-Trans Corp · Denton, TXN812HWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN813AMAir Methods LLC · Greenwood Village, CON814FCentral Copters Inc · Belgrade, MTN814MCMartin County Sheriffs Office · Stuart, FLN814SMAir Methods LLC · Greenwood Village, CON814XSpeculator Air LLC · Billings, MTN816CESouthern California Edison Co · Chino, CAN817CESouthern California Edison Co · Chino, CAN818HAHelinet Aviation Services LLC · Van Nuys, CAN818PDCity Of Glendale · Glendale, CAN819TXTexas Department Of Public Safety · Austin, TXN821MHMustang Leasing LLC · Henderson, NVN821PDEast Bay Regional Park District · Livermore, CAN821SSFly Safe LLC · Wilmington, DEN822MHMustang Leasing LLC · Henderson, NVN823CRIron Blonde LLC · Lewes, DEN823MHMustang Leasing LLC · Henderson, NVN824TXTexas Department Of Public Safety · Austin, TXN826AHAurora Air LLC · Kalispell, MTN82769Ns Air Leasing LLC · Wilmington, DEN829TCBank Of Utah Trustee · Salt Lake City, UTN82AHArrow Aviation Company LLC · Broussard, LAN82MDBank Of Utah Trustee · Salt Lake City, UTN830PANs Air Leasing LLC · Wilmington, DE
Back to AD 2016-25-13