AD 2002-20-03
Registered aircraft · 995
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:2002-20-03')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-20-03')
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:2002-20-03') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-20-03') 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.
N267LALapd Air Support Division · Los Angeles, CAN268JAirbus Helicopters Inc · Grand Prairie, TXN26HXNs Air Leasing LLC · Wilmington, DEN270PWTexas Parks And Wildlife Department · Austin, TXN274CHWalker Kenneth E · Ford City, PAN275BPCity Of Burbank · Burbank, CAN2770KAirbus Helicopters Inc · Grand Prairie, TXNon-citizen corporation, flight hours not reportedN279AMAir Methods LLC · Greenwood Village, CON279CHCoastal Helicopters Inc · Juneau, AKN27WAWings Air Helicopters LLC · West Harrison, NYN288WSWorld Trade Enterprises LLC · Lucas, TXN28LBCity Of Long Beach · Long Beach, CAN2907ADepartment Of Homeland Security · Washington, DCN295JAb Air Ltd · Canton, OHN296PDCity Of Philadelphia · Philadelphia, PAN296SDepartment Of Homeland Security · Washington, DCN296WAirbus Helicopters Inc · Grand Prairie, TXN297PDCity Of Philadelphia · Philadelphia, PAN297SHJc Aircraft Leasing LLC · Wasilla, AKN29GFAirman Helicopter Inc · Fort Lauderdale, FLN29HDHelinet Aviation Services LLC · Van Nuys, CAN29LBCity Of Long Beach · Long Beach, CAN29LWTiny Bubbles Aviation Inc · Pacoima, CAN2SDPinellas County Sheriff'S Office · Clearwater, FLN2SWEcho Matrix LLC · Bentonville, ARN300EVAeroxs Inc · Swainsboro, GAN301CHCoastal 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, UTN308MPMiami-Dade Sheriffs Office · Doral, FLN309MPMiami-Dade Sheriffs Office · Doral, FLN30NTCity Of Ontario · Ontario, CAN310SWWings Air Helicopters LLC · West Harrison, NYN312BPatriot Aviation Inc · Greenville, DEN312SDHarris County Sheriffs Office · Spring, TXN316BJLama French Alps Inc Trustee · Wilmington, DEN316ELMercy Air Helicopter Inc · Fort Lauderdale, FLN316TXRosenberg Adrian · Laupahoehoe, HIN318MGNs Air Leasing LLC · Wilmington, DEN31BHBrainerd Helicopters Inc · Leesburg, FLN31NSTemsco Helicopters Inc · Ketchikan, AKN320PANs Air Leasing LLC · Wilmington, DEN322AHSuperior Helicopter Services LLC · Indianapolis, INN322VDepartment Of Homeland Security · Washington, DCN323AHBristow LLC · Lake Charles, LA
Back to AD 2002-20-03