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.

N65UDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1967 · S/N LM-87 N65VDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1968 · S/N LM-113 N660KPWorsham Farms Flying Service Inc · Camilla, GAS/N T660-122DC N660MCMcguires Flying Service LLC · Obion, TNBuilt 2024 · S/N T660-185DC N660TRTri-Rotor Spray & Chemical · Ulysses, KSBuilt 2000 · S/N T660-106 N661EKGi Aviation LLC · Denver, COS/N 61 N661MAAramco Capital Company LLC · DhahranBuilt 1998 · S/N 802A-0057 N661WAKapowsin Air Sports Ltd · Shelton, WABuilt 1998 · S/N 208B0661 N662LMFreedom LLC · Pass Christian, MSBuilt 2002 · S/N 208B0978 N662MAAramco Capital Company LLC · DhahranBuilt 1996 · S/N 802-0037 N663LAAurora Cooperative Elevator Co · Aurora, NEBuilt 2003 · S/N 502B-0663 N665JKN665jk LLC · Boca Raton, FLBuilt 1975 · S/N LJ665 N666BZCorrao Ludwig Jerome Trustee · Reno, NVBuilt 2019 · S/N 20800652 N666JMBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2025 · S/N 2468 N667CBDevil Dusters Inc · Artesia, NMBuilt 2003 · S/N 502B-0667 N669BABlue Air Training Corp · Las Vegas, NVBuilt 1988 · S/N 507 N669JWKapowsin Air Sports Ltd · Shelton, WABuilt 1968 · S/N 088 N66WDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1967 · S/N LM-68 N670TCBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 208B2374 N671AZPima County Board Of Supervisors · Tucson, AZBuilt 2021 · S/N 20800671 N671RAReliable Robotics Corp · Mountain View, CABuilt 1996 · S/N 208B0539 N672AZPima County Board Of Supervisors · Tucson, AZBuilt 2021 · S/N 20800673 N6750Z50 Zulu Aviation LLC · Williamston, MIBuilt 2012 · S/N 208B2340 N675JZMercer Fraser Co · Brookings, ORBuilt 2015 · S/N 20800570 N675SMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 20800675 N676WTHat L Management Inc · Midland, TXBuilt 1981 · S/N BB-872 N677PJmc Air LLC · Dillsburg, PABuilt 1992 · S/N 1019 N678ABHeart Rhythm Center Of Mississippi LLC · Flowood, MSBuilt 2001 · S/N 4697041 N67BAFlorida State Guard · Tallahassee, FLBuilt 1981 · S/N 425-0007 N67BWHarvey Robert B Jr · Fort Worth, TXBuilt 2000 · S/N 46-97011 N67CQBeech Baron LLC · Wilmington, NCBuilt 2000 · S/N LJ-1619 N67DWDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N 31T-7620041 N67KDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1967 · S/N LM-24 N681CAJet Air Inc · Galesburg, ILBuilt 1995 · S/N LJ-1414 N682ACDesert Sand Aircraft Leasing Co Inc · Rosharon, TXBuilt 2003 · S/N 208B1027 N683KRPeterson Tony D · Humboldt, IABuilt 2004 · S/N 602-0683 N683MG1976 King LLC · Scottsdale, AZBuilt 1976 · S/N LJ-683 N684SAUnited States Department Of State · Melbourne, FLBuilt 1998 · S/N 208B0684 N688MCFlight Management LLC · Kirkland, WABuilt 2001 · S/N 20800347 N689KAKamaka Air LLC · Honolulu, HIBuilt 2011 · S/N 208B2308 N68BJCrownair LLC · Mansfield, PABuilt 1979 · S/N 31T7920029 N68TFRegistered aircraftS/N 26 N690MFDesert Sand Aircraft Leasing Co Inc · Rosharon, TXBuilt 1968 · S/N 121 N6925YPleasant Aviation LLC · Mount Pleasant, TXBuilt 1978 · S/N GM-94 N692DADirect Action Aviation LLC · Reno, NVBuilt 1968 · S/N 151 N692MPWoodley Aerial Leasing LLC · Walnut, ILBuilt 1992 · S/N 502A-0182 N694DADirect Action Aviation LLC · Reno, NVBuilt 1991 · S/N 208B0266 N695LAMurphree Flying Service Inc · Crystal Beach, TXBuilt 2004 · S/N 602-0695 N695STKraemericair LLC · Saint Louis, MOBuilt 2021 · S/N 4698195 N697PStaker & Parson Co · Ogden, UTBuilt 1985 · S/N BB1217

Back to AD 2014-17-08 R1