AD 2000-16-52
Registered aircraft · 647
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:2000-16-52')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-16-52')
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:2000-16-52') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-16-52') 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.
N352HPState Of Utah · Salt Lake City, UTN352PAPathfinder Leasing LLC · Anchorage, AKN352RNs Air Leasing LLC · Wilmington, DEN352SASycan Corp DBA · Paso Robles, CAN353CEAviation Advantage Inc · Tabor City, NCN353EReeder Flying Service Inc · Twin Falls, IDN353FBNs Air Leasing LLC · Wilmington, DEN353HPState Of Utah · Salt Lake City, UTN353JRPrecision LLC · Mcminnville, ORN353MHPathfinder Leasing LLC · Anchorage, AKN353PPhi Health LLC · Tempe, AZN353SHSycan Corp DBA · Paso Robles, CAN354CFRegistration Pending · Greenwood Village, CORegistration pendingN354EReeder Flying Service Inc · Twin Falls, IDN354HPState Of Utah · Salt Lake City, UTN354LASale Reported · Milton, VTSale reported, canceledN354PPhi Health LLC · Tempe, AZN354PAPathfinder Leasing LLC · Anchorage, AKN354SHSycan Corp DBA · Paso Robles, CAN355AMAir Methods LLC · Greenwood Village, CON355CFAir Methods LLC · Greenwood Village, CON356KJB&R Trucking Inc · Carlsbad, NMN356PPhi Health LLC · Tempe, AZN357KVKavecol Inmobiliaria Inc · Guaynabo, PRN357PAPathfinder Leasing LLC · Anchorage, AKN358PAPathfinder Leasing LLC · Anchorage, AKN358SHSycan Corp DBA · Paso Robles, CAN359EVAlaska Remote Outfitters LLC · Kenai, AKN359FBPhoenix Police Department · Phoenix, AZN359PANs Air Leasing LLC · Wilmington, DEN359SHPaso Air Leasing LLC · Paso Robles, CAN35HXHelicopter Express LLC · Chamblee, GAN361TXTexas Department Of Public Safety · Austin, TXN362ACBank Of Utah Trustee · Salt Lake City, UTN364TARoberts Aircraft LLC · Cheyenne, WYN369WMTeam C & H Inc · Jacksonville, FLN370HPOklahoma Department Of Public Safety · Norman, OKN370NCState Of North Carolina · Raleigh, NCN370SRDepartment Of Homeland Security · Washington, DCN377GRAirbus Helicopters Inc · Grand Prairie, TXN381ZDepartment Of Homeland Security · Washington, DCN382BMCity Of San Antonio · San Antonio, TXN382PPhi Health LLC · Tempe, AZN3831Air Methods LLC · Greenwood Village, CON383AKAlpha Aviation LLC · Anchorage, AKN384PPhi Health LLC · Tempe, AZN385AKAlpha Aviation LLC · Anchorage, AKN386AKAlpha Aviation LLC · Anchorage, AKN386PPhi Health LLC · Tempe, AZN387AK387ak LLC · Anchorage, AK
Back to AD 2000-16-52