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.

N703DCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 20800366 N703FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0423 N704MDNv5 Geospatial Inc · Sheboygan Falls, WIBuilt 2004 · S/N 208B1076 N705FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0425 N705GGUnited States Government · Fort Belvoir, VABuilt 1981 · S/N 48 N706JRDodson International Parts Inc · Rantoul, KSS/N 42-5501050 N706LBRf Logistics Inc · Santa Teresa, NMBuilt 1981 · S/N 4250033 N706ZHlm706z Inc · Bismarck, NDBuilt 2000 · S/N 4636256 N707AVCarvair LLC · New York, NYBuilt 2001 · S/N 197 N707FBBolea Air Inc · Morgan Hill, CAS/N 177 N707FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0427 N707WFCannery Leasing Ltd · Friday Harbor, WABuilt 2014 · S/N 20800562 N708EFDejong Merritt · Newburgh, INS/N 21 N708KAJb Leasing Company LLC · Kenai, AKBuilt 1954 · S/N 59 N708PVPm Leasing Inc · Perris, CABuilt 1976 · S/N 489 N708SAOlivier Seth Nicholas · Baskin, LABuilt 1981 · S/N 31T-8104042 N709FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0430 N70AVQualitair LLC Trustee · MichelstadtBuilt 1991 · S/N 6 N70CULou Dell Aviation LLC · Simpsonville, SCBuilt 1981 · S/N BB-888 N70EAEagle Air Transport · Ottawa, ILS/N 139 N70LTBarren Troy Aviation LLC · Centennial, COBuilt 1999 · S/N 151 N70MNState Of Minnesota · Saint Paul, MNBuilt 1993 · S/N BB-1447 N70RMRem Industries LLC · Farragut, TNBuilt 2024 · S/N 46020013 N70VRSkeeterhawk Aero LLC · Sheridan, WYBuilt 2001 · S/N LJ1651 N71Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-6 N710FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0431 N710GWGoing To Work Aviation LLC · Wildwood, FLBuilt 1998 · S/N FL-228 N710LWWerth Lance C · Johnson Lake, NEBuilt 2023 · S/N T660-175 N711FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0433 N711PMVinton Aero LLC · Cedar Springs, MIBuilt 2002 · S/N 234 N711SBCashsouth LLC · Georgetown, DEBuilt 2001 · S/N 4697075 N711VNKa350 N711vn LLC · Plano, TXBuilt 1990 · S/N FL-7 N711VVMaynard Aviation LLC · Westfield, MABuilt 1990 · S/N BB-1365 N7125NKsnl Aero LLC · Shawnee, OKBuilt 2015 · S/N 208B5235 N712FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0435 N712FYAddison Automatics Inc · Harmon, ILBuilt 2024 · S/N 46020012 N712MKAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1986 · S/N 4608032 N713CBCaravan Charters LLC · Richmond, VABuilt 2005 · S/N 208B1106 N713FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0438 N713RHFalcon Air LLC · Olive Branch, MSBuilt 1987 · S/N BB-1274 N714WVPeasant Air LLC · Middletown, DEBuilt 2005 · S/N 614 N71562Kalche Aviation LLC · Baton Rouge, LABuilt 2001 · S/N 4697081 N715FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0440 N715HETatonduk Outfitters Ltd DBA · Fairbanks, AKBuilt 1997 · S/N 208B0603 N715VTnt Operations LLC · Missoula, MTBuilt 1995 · S/N 108 N716BMTraveling Toes LLC · Wilmington, DEBuilt 1993 · S/N FL-103 N716ESFlorida Fish And Wildlife Conservation Commission · Lakeland, FLBuilt 2023 · S/N 20800694 N716FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0442 N716TAB P Air LLC · Delhi, LAFirst renewal noticeBuilt 1995 · S/N BB-1509 N717FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0445

Back to AD 2014-17-08 R1