Skip to content

AD 2014-17-08 R1

Registered aircraft · 2,524

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.

N61366Plantation Flyers LLC · Lettsworth, LABuilt 1996 · S/N 502B-0374 N6136HAurora Cooperative Elevator Company · Aurora, NEBuilt 1995 · S/N 802A-0017 N6136MEdwards Flying Service Inc · Leland, MSBuilt 1995 · S/N 502B-0341 N61373H & G Farms Inc · Corcoran, CABuilt 1996 · S/N T34-216 N6139VRussel Armstrong & Danny Hawk DBA Onstott Dusters · Yuba City, CABuilt 1995 · S/N 402B-0982 N613GGNcp Equipment LLC · Wilmington, DEBuilt 1998 · S/N LJ-1506 N613RFB R S Leasing Inc · Wilmington, DEBuilt 1983 · S/N LJ-1068 N613TREquipment King LLC · Waco, TXBuilt 1998 · S/N FL-230 N6142MGentrys Flying Service LLC · Prattville, ALBuilt 1994 · S/N 502B-0269 N6143LCkw Aviation LLC · Dalhart, TXBuilt 1996 · S/N 502A-0350 N6147YStraight Flight Nevada Commercial Leasing LLC · Sparks, NVBuilt 2009 · S/N 208B2096 N61481Aerial Crop Protection Inc · Belle Glade, FLBuilt 1996 · S/N 502B-0371 N6148TAllen Air Ltd LLC · Wray, COBuilt 1995 · S/N 802A-0022 N614MWCrider Flying Service Inc · Swifton, ARBuilt 2000 · S/N 502A-0614 N6159VStraight Flight Nevada Commercial Leasing LLC · Sparks, NVBuilt 2009 · S/N 208B2106 N6160GChapman Cody A · Wray, COS/N 502B-0358 N6164QRunsick Michael C DBA · Wynne, ARBuilt 1996 · S/N 502B-0384 N6165CAir Care Leasing LLC · Lamar, COBuilt 1996 · S/N 502B-0379 N6165UTailwinds Air Inc · Morganza, LABuilt 1996 · S/N 502B-0381 N61664Arthur Aviation LLC · Arthur, NDBuilt 1996 · S/N 502B-0382 N616EAEmpireair LLC · Spokane Valley, WAFirst renewal noticeBuilt 2005 · S/N 616 N616JBAdams Aerial Solutions LLC · Decatur, ILBuilt 1997 · S/N 402A-1033 N6170XWest Hills Aviation Inc · Huron, CABuilt 1996 · S/N 502B-0372 N61729Marine Connection Leasing LLC · Vero Beach, FLBuilt 2009 · S/N 208B2135 N6174HWoodley Aerial Leasing LLC · Walnut, ILBuilt 1995 · S/N 402B-0994 N6175STri-Rotor Spray And Chemical · Ulysses, KSBuilt 1995 · S/N 402B-0993 N6176LTrinkle Aviation LLC · Kingsburg, CABuilt 1996 · S/N 502A-0352 N6176YRegistered aircraftBuilt 1996 · S/N 802-0036 N6177JMcginty Flying Service LLC · Jones, LABuilt 1995 · S/N 502B-0327 N617STSartec Corp · Pensacola, FLBuilt 2004 · S/N 208B1044 N6180UParrish Aerial Services LLC · Wilmington, DEBuilt 1996 · S/N 502B-0390 N6181QPioneer Agviation 2 LLC · Holdrege, NEBuilt 1996 · S/N 502B-0395 N6182AA&R Air Inc · Hinsdale, ILBuilt 1994 · S/N BB-1484 N618JCMclean Aviation Services Inc · Napa, CABuilt 2005 · S/N 618 N618MAAir Matrix LLC · Lomita, CABuilt 2005 · S/N 4697218 N618SLewis Aeronautical LLC · San Antonio, TXS/N 618 N619MAKenmore Air Harbor LLC · Kenmore, WABuilt 2010 · S/N 208B2192 N619PAPafford Air Of Mississippi LLC · Ruston, LABuilt 1993 · S/N BB-1458 N619TKRegistered aircraftBuilt 2006 · S/N 4697243 N61DJBlack Badge Aviation LLC · Carson City, NVBuilt 1991 · S/N 760380 N61DNDn2 Aviation LLC · Fernandina Beach, FLBuilt 1992 · S/N BB-1438 N61WAWacouta Aircraft Leasing LLC · Las Vegas, NVBuilt 2025 · S/N 20800718 N620NRak Tbvr LLC · Middletown, DEBuilt 1957 · S/N 1026 N620WALaboratory Corporation Of America Holdings · Burlington, NCBuilt 2005 · S/N 620 N621GZHfjw Properties Leasing LLC · Santa Rosa Beach, FLBuilt 1998 · S/N FL-197 N621KTDdm Aviation LLC · Coral Gables, FLBuilt 2021 · S/N 20800674 N621NHorizon Aviation LLC · Kalispell, MTBuilt 2004 · S/N 4697177 N622FCRegistered aircraftN-number assigned, not yet registeredS/N 35048 N622KMK & M Equipment Co LLC · Chatsworth, CABuilt 1981 · S/N BB-491 N623BALmco · Vandenberg Afb, CABuilt 2005 · S/N 623

Back to AD 2014-17-08 R1