AD 2002-03-52
Registered aircraft · 1,115
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-03-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:2002-03-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:2002-03-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:2002-03-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.
N249AHAirbus Helicopters Inc · Grand Prairie, TXN250AMAir Methods LLC · Greenwood Village, CON251HIsland Helicopters Kauai Inc · Lihue, HIN252CHCoastal Helicopters Inc · Juneau, AKN253AHAirbus Helicopters Inc · Grand Prairie, TXN253CHCoastal Helicopters Inc · Juneau, AKN253LFAir Methods LLC · Greenwood Village, CON255LFAir Methods LLC · Greenwood Village, CON255PJArk Aviation LLC · Central City, KYN255RMCgcpr LLC · Canovanas, PRN257AMAir Methods LLC · Greenwood Village, CON259AMAir Methods LLC · Greenwood Village, CON261AWAll Wool Aviation LLC · Coral Gables, FLN261NDepartment 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, CAN267RCBank Of Utah Trustee · Salt Lake City, UTN268JAirbus 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, ARN301CHCoastal Helicopters Inc · Juneau, AKN302CHCoastal Helicopters Inc · Juneau, AKN302SCUsaircraft Inc · Newark, DEN302TPCity Of Tulsa · Tulsa, OKN304MPMiami-Dade Sheriff'S Office · Doral, FLN305MPMiami-Dade Sheriff'S Office · Doral, FL
Back to AD 2002-03-52