AD 2002-23-11
Registered aircraft · 1,985
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-23-11')
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-23-11')
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-23-11') 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-23-11') 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.
N113AXAlaska Central Express Inc · Anchorage, AKN114AXAlpine Aviation Inc · Provo, UTN114CWMatagorda Production Co · Houston, TXN114HBEaglemed LLC · Wichita, KSN115AXAlaska Central Express Inc · Anchorage, AKN115CTChastang Lawrence · Orlando, FLN115HDepartment Of Homeland Security · Washington, DCN115TTNo Delay LLC · Tickfaw, LAN1167ADakota Wings Of Delaware LLC · Sioux Falls, SDN116NDepartment Of Homeland Security · Washington, DCN116TXPlacid Air LLC · Naples, FLN117AXAlaska Central Express Inc · Anchorage, AKN117EMAdams Aviation Services Inc Trustee · Wilmington, DEN117TJCoastal Community Real Estate Group LLC · Caswell Beach, NCN118AXAlaska Central Express Inc · Anchorage, AKN118SBEaglemed LLC · Wichita, KSN119ARCsc Delaware Trust Co Trustee · Wilmington, DEN119AXAlaska Central Express Inc · Anchorage, AKN119MCAgave III LLC · Seattle, WAN11WNRds Aviation LLC · Elkhart, INN120NCDavis Aviation Inc DBA · Brandon, MSN120RLIsr Platforms LLC · Mclean, VAN120UCAlpine Aviation Inc · Provo, UTN1212International Air Services Inc Trustee · Carson City, NVN1213PL7 Air LLC · Chandler, AZN121DKAutomotive Air II LLC · Belcamp, MDN121LBEastern Stearman Inc Trustee · Leesburg, VAN1221FTj Air Holdings Inc Trustee · Wilmington, DEN122BKFlying Mixers LLC · Amarillo, TXN122RGRiversville Aircraft Corp · Belgrade Lakes, MEN122UXAlpine Aviation Inc · Provo, UTN123CHMdi Air LLC · Dothan, ALN123HGHorowitz Transportation LLC · Newport Beach, CAN123MLNfbn LLC · Scottsdale, AZN123RFLucky Air LLC · Hobbs, NMN124AXAlaska Central Express Inc · Anchorage, AKN124CMSolomon Mark Trustee · Wilmington, DEN124EBPremium Air LLC · Hibbing, MNN124GADriscoll Health Care Services · Corpus Christi, TXN124GPAlpine Aviation Inc · Provo, UTN124KTGams Air LLC · Doral, FLN124WRH.A.I. Services Inc · Justin, TXN1253VBane Patricia L · Midland, TXN1253WWorthington Enterprises Inc · Columbus, OHN125AXAlaska Central Express Inc · Anchorage, AKN125BAAlpine Aviation Inc · Provo, UTN125BKColoramo Federal Credit Union · Grand Junction, CON125KAAirmax LLC · Lancaster, SCN125KSAlpine Aviation Inc · Provo, UTN125TECj Brown Express LLC · Graettinger, IA
Back to AD 2002-23-11