Registered aircraft · 2,525

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

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:2014-17-08-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2014-17-08-R1') ORDER BY n_number

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:2014-17-08-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2014-17-08-R1')
  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:2014-17-08-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2014-17-08-R1')
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.

N162MCBank Of Utah Trustee · Salt Lake City, UTS/N B137 N162QMartin Foundry Service Inc · Glencoe, ALBuilt 1982 · S/N BB-1104 N163KAAdvanced Global Services Inc · Vero Beach, FLBuilt 2024 · S/N 46020016 N1655MMichigan Aeronautics Commission · Lansing, MIBuilt 1999 · S/N BB-1655 N165TGAmj Aviation LLC · Oneida, TNBuilt 1997 · S/N FL-165 N165YVAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-165 N166CLKa Partners LLC · Thomson, GABuilt 2000 · S/N FL-298 N166DHRandigo LLC · Wilmington, DEBuilt 1967 · S/N 66 N166LAAeronautical Technologies Inc · Clovis, NMBuilt 2004 · S/N 802A-0166 N166SAClear Skies Ltd · Cincinnati, OHBuilt 1988 · S/N FA-166 N167BBCentral Virginia Aviation Inc · Petersburg, VABuilt 1983 · S/N LJ-1054 N168CWXu Zhaohui Executor · Memphis, TNS/N 30 N168LMArne Aviation LLC · Suffolk, VABuilt 1985 · S/N SH-3104 N168MARunway Vineyards LLC · Santa Maria, CAS/N 4250155 N168RFRandigo LLC · Wilmington, DEBuilt 1989 · S/N 20800158 N169BADesert Sand Aircraft Leasing Co Inc · Rosharon, TXBuilt 1967 · S/N 103 N169GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-169 N16HGBear Air LLC · Mount Vernon, INBuilt 1999 · S/N BB-1647 N16KWWild Blue Aviation LLC · Wilmington, DEBuilt 1996 · S/N LJ-1435 N16TBEager Beaver LLC · San Diego, CABuilt 1968 · S/N 1679TB47 N16TMTriad Physician Resources Inc · Longview, TXBuilt 1998 · S/N LJ-1507 N170GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-170 N170JCWlgb200 LLC · Reno, NVBuilt 1998 · S/N BB-1606 N171GCRigidworks LLC · Anaconda, MTBuilt 1974 · S/N 406 N171SCotterkey N171s LLC · Phoenix, AZBuilt 2017 · S/N EVO-0079 N173KSCentralav LLC · Lake Worth, FLS/N FA-82 N175LAMitchell Andrew D Trustee · Winnie, TXBuilt 2004 · S/N 802A-0175 N175SAGeneral Atomics · San Diego, CABuilt 1976 · S/N BB-183 N175WBHerdair Group LLC · Conroe, TXBuilt 2004 · S/N 4697181 N176YVHill Air Executive Inc · Fort Pierce, FLBuilt 1995 · S/N UE-176 N177CNRca Aviation 2 LLC · Tempe, AZBuilt 1984 · S/N BB-1191 N177LACabeza De Vaca Holdings LLC · Carrollton, TXBuilt 1985 · S/N BB1203 N177RAUnited States Government · Fort Belvoir, VABuilt 1982 · S/N 85 N1789MMjr Aviation Consultants LLC · Clearwater, FLBuilt 2010 · S/N 208B2245 N178YVAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-178 N179MDGem City Properties LLC · Laramie, WYS/N LJ-1091 N179SAPriority Air Charter LLC · Kidron, OHBuilt 1997 · S/N 208B0594 N17KKRiverbend Aviation LLC · Hernando, MSBuilt 1998 · S/N LJ-1318 N17LHHigh Flying Investments LLC · Texarkana, ARBuilt 2000 · S/N 46-97007 N17YLYowell Legacy Aviation LLC · Killeen, TXBuilt 1990 · S/N FL-1 N180AVAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1996 · S/N 1018 N180GCZuni LLC · Kirkland, WABuilt 2009 · S/N 208B2085 N183CTUltimate Resort Vacations Inc · Weston, FLBuilt 2010 · S/N 208B2183 N183SADriscoll David A · Savannah, TNBuilt 1973 · S/N LJ571 N18471Chase Air LLC · Montgomery, ALBuilt 1981 · S/N LA-161 N1848ST&T Air LLC · Lindsay, OKBuilt 1996 · S/N LJ-1455 N184AEN184ae LLC · Ault, COBuilt 2000 · S/N 4697026 N184UXAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-184 N186DCAir Care Inc · Lamar, COBuilt 1992 · S/N 502-0186 N186PSRricko LLC · Portland, ORS/N 4697228

Back to AD 2014-17-08 R1