AD 2002-15-08
Registered aircraft · 1,064
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-15-08')
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-15-08')
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-15-08') 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-15-08') 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.
N2374FTexas 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, DEN244TXBrenthel Industries LLC · Helena, MTN247HHIntegrity Aircraft Title Holdings LLC · Portland, ORN249AHAirbus Helicopters Inc · Grand Prairie, TXN250AMAir Methods LLC · Greenwood Village, CON250KMHeliec120 LLC · Wilmington, DEN251HIsland 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, KYN255SDSacramento County Sheriffs Office · Mather, CAN257AMAir Methods LLC · Greenwood Village, CON261AWAll Wool Aviation LLC · Coral Gables, FLN261NDepartment Of Homeland Security · Washington, DCN262TWRegistered aircraftN263CPSouthern Aircraft Consultancy Inc Trustee · Casper, WYN2658Department Of Homeland Security · Washington, DCN265CB210 Partners LLC · Lutz, FLN266SDSacramento County Sheriffs Department · Mather, CAN267ADepartment 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, TXN274CHWalker Kenneth E · Ford City, PAN275BPCity Of Burbank · Burbank, CAN2770KAirbus Helicopters Inc · Grand Prairie, TXNon-citizen corporation, flight hours not reportedN277SDSacramento County Sheriffs Office · Mather, CAN279AMAir Methods LLC · Greenwood Village, CON279CHCoastal Helicopters Inc · Juneau, AKN279EHAircraft Trustee Services Inc Trustee · Dover, DEN27GTSouthern Aircraft Consultancy Inc Trustee · Casper, WYN27WAWings Air Helicopters LLC · West Harrison, NYN288JKCounty Of Sacramento · Mather, CAN288WSWorld 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, DC
Back to AD 2002-15-08