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.
N227TXTexas Department Of Public Safety · Austin, TXN229AHMiller Jason · Scottsdale, AZN229MTMed-Trans Corp · Denton, TXN230AHAir Methods LLC · Greenwood Village, CON230LALapd Air Support Division · Los Angeles, CAN232LACity Of Los Angeles · Los Angeles, CAN232SHJc Aircraft Leasing LLC · Wasilla, AKN233LACity Of Los Angeles · Los Angeles, CAN233PAComanche Maverick Air LLC · Houston, TXN234BHBrainerd Helicopters Inc · Leesburg, FLN2374FTexas Department Of Public Safety · Austin, TXN237BSSky High Leasing LLC · Montrose, CON239AHAirbus Helicopters Inc · Grand Prairie, TXN23HSVertical Corp · Kalispell, MTN242ADepartment Of Homeland Security · Washington, DCN243GCGranite Coast Mapping · Coronado, CAN244CPAircraft Trustee Services Inc Trustee · Dover, DEN249AHAirbus Helicopters Inc · Grand Prairie, TXN250AMAir Methods LLC · Greenwood Village, CON253AHAirbus Helicopters Inc · Grand Prairie, TXN253LFAir Methods LLC · Greenwood Village, CON255LFAir Methods LLC · Greenwood Village, CON255PJArk Aviation LLC · Central City, KYN257AMAir Methods LLC · Greenwood Village, CON261NDepartment Of Homeland Security · Washington, DCN262TWRegistered aircraftN2658Department Of Homeland Security · Washington, DCN267ADepartment Of Homeland Security · Washington, DCN267AMAir Methods LLC · Greenwood Village, CON267LALapd Air Support Division · Los Angeles, CAN268JAirbus Helicopters Inc · Grand Prairie, TXN26HXNs Air Leasing LLC · Wilmington, DEN270PWTexas Parks And Wildlife Department · Austin, TXN2770KAirbus Helicopters Inc · Grand Prairie, TXNon-citizen corporation, flight hours not reportedN279AMAir Methods LLC · Greenwood Village, CON2907ADepartment Of Homeland Security · Washington, DCN295JAb Air Ltd · Canton, OHN296SDepartment Of Homeland Security · Washington, DCN296WAirbus Helicopters Inc · Grand Prairie, TXN297SHJc Aircraft Leasing LLC · Wasilla, AKN29GFAirman Helicopter Inc · Fort Lauderdale, FLN2SWEcho Matrix LLC · Bentonville, ARN301CHCoastal Helicopters Inc · Juneau, AKN302CHCoastal Helicopters Inc · Juneau, AKN302TPCity Of Tulsa · Tulsa, OKN304MPMiami-Dade Sheriff'S Office · Doral, FLN305MPMiami-Dade Sheriff'S Office · Doral, FLN306MPMiami-Dade Sheriffs Office · Doral, FLN307MPMiami-Dade Sheriffs Office · Doral, FLN308ACBank Of Utah Trustee · Salt Lake City, UT
Back to AD 2000-16-52