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.

N807EVRegistered aircraftS/N 208B0807 N807FERegistration Pending · Mountain View, CARegistration pendingBuilt 1987 · S/N 208B0041 N807JAAv Serv LLC · Dover, DEBuilt 1985 · S/N 20800075 N808MABank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 208B2427 N808SWFmgi Inc · Woodstock, GABuilt 1978 · S/N LJ801 N808TRTrans Executive Airlines Of Hawaii Inc DBA · Honolulu, HIBuilt 1987 · S/N SH3718 N8096UWhitty Aviation LLC · Rocklin, CABuilt 1993 · S/N LJ-1326 N809SATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1986 · S/N 20800081 N80KLLiberty Leasing Vii LLC · Melbourne, FLBuilt 2007 · S/N 20800411 N80MALsc Construction Inc · Perris, CAS/N 31T7720043 N80PMSouthbreeze Aviation LLC · Wellington, FLBuilt 1983 · S/N 425-0181 N80RDRobert Wiplinger LLC · Inver Grove, MNBuilt 1986 · S/N 20800085 N80TMRad Holding I LLC · Olympia, WABuilt 2011 · S/N 259SR N810VJVee Jay Equipment (De) LLC · Clarkston, MIBuilt 2005 · S/N 610 N8116NStingray Aviation LLC · Visalia, CABuilt 1991 · S/N FL-58 N811LSTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 208B2212 N813DGBristow LLC · Lake Charles, LABuilt 2006 · S/N 31032 N8149SIcu.Net Inc · Tulsa, OKBuilt 1993 · S/N NC-35 N814BCRegistered aircraftS/N 548 N814GVIsr Aviation LLC · Wilmington, DEBuilt 2002 · S/N 208B0958 N814LCN814 LLC · Dover, DEBuilt 1990 · S/N LJ1247 N8156ZWings Of Dawn LLC · Valley Center, KSBuilt 1993 · S/N LJ-1333 N8158XPatterson Frederick W III · American Canyon, CAS/N NC-42 N815CFMeridian Air LLC · New Boston, MIBuilt 2006 · S/N 4697242 N816BPAls Aviation LLC · Westlake Village, CABuilt 1985 · S/N 480 N816BSN811kc LLC · Sunrise, FLBuilt 1992 · S/N BB-1440 N816GGGoodwin Bryan · Fort Smith, ARBuilt 2019 · S/N 4697658 N81820Uas Transervices Inc · Boca Raton, FLBuilt 1987 · S/N U232 N818FWPelican Aircraft Inc · Wilmington, DEBuilt 1991 · S/N BB-1394 N818JCVogel Engineers Inc · Walnut, CABuilt 2025 · S/N K098 N819EEVaquero Skies LLC · El Paso, TXBuilt 1997 · S/N FL-187 N819KMSahalee Air LLC · Covington, WABuilt 2006 · S/N 208B1215 N819MHC&W Logistics LLC · Garden City, KSFirst renewal noticeBuilt 1977 · S/N LJ-735 N81BLScott Manufacturing LLC · Henderson, KYBuilt 2003 · S/N 4697160 N81SUMedary Aviation LLC · Brookings, SDBuilt 1989 · S/N LJ-1194 N820BHVertical Air Inc · Deland, FLBuilt 1989 · S/N 208B0153 N820FEFederal Express Corporation · Memphis, TNBuilt 1992 · S/N 208B0111 N820GMSecond Wind LLC · Tallahassee, FLBuilt 2024 · S/N 46020031 N820RDImhof Air 2 LLC · Ferndale, WABuilt 1973 · S/N LW-82 N821JRegistration Pending · West Branch, MIRegistration pendingBuilt 2003 · S/N 4697172 N8226ZUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-190 N8227PUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-194 N822MMBristow LLC · Lake Charles, LABuilt 2005 · S/N 14055 N823EBIdi Aviation LLC · Indianapolis, INBuilt 1998 · S/N FL-227 N823XTransport Services LLC · Birmingham, ALS/N 823 N8244LAircraft Partner N8244l Dst · Wilmington, DEBuilt 1992 · S/N NC-29 N825BKKlein Flying Service · Lawrenceville, ILBuilt 1993 · S/N 402-0902 N825KASav Aviation LLC · Jacksonville, TXS/N BB-825 N825SDGreat Valley Management Inc · New Castle, DEFirst renewal noticeBuilt 1996 · S/N LJ-1449 N826XTransport Services LLC · Birmingham, ALBuilt 1985 · S/N 826

Back to AD 2014-17-08 R1