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.

N1502UCentral Ag Air LLC · Marion, KSBuilt 1991 · S/N 502-0139 N15054Air-Ag Inc · Tarboro, NCBuilt 1991 · S/N 402A-0823 N15074Wells Flying Services LLC · Holdrege, NEBuilt 1991 · S/N 402A-0825 N1507KDakota Air Spray LLC · Huron, SDBuilt 1991 · S/N 502-0142 N150ACJohnson Airspray Inc · Argyle, MNBuilt 1991 · S/N T34-150 N150GWRocinante Air LLC · Cincinnati, OHBuilt 1998 · S/N LJ-1531 N15102Moes Crop Dusting Service Inc · Marysville, CABuilt 1991 · S/N 502-0146 N1515GKidd Clifford L · Monahans, TXBuilt 1991 · S/N 502-0152 N15189Tri Rotor Spray & Chemical · Ulysses, KSBuilt 1991 · S/N 502-0155 N1518ZMoss Jimmy David DBA · Tillar, ARBuilt 1991 · S/N 402-0837 N1519ZFlatland Aviation LLC · Indianola, MSBuilt 1991 · S/N 502-0156 N151CAAcc Integrated Services Inc · Milwaukee, WIBuilt 1984 · S/N SH3653 N151CLAircraft Structures International Corp · Enid, OKBuilt 1988 · S/N 208B0083 N1520QBrekhus Julius P · Kenmare, NDBuilt 1991 · S/N 402-0838 N15210O'Hare R Mike · Clovis, NMBuilt 1991 · S/N 402-0840 N1529ERoth Aerial Spraying LLC · Milford, NEBuilt 1991 · S/N 502-0161 N1529HMiller Aviation Inc · Norton, KSBuilt 1992 · S/N 502A-0158 N1529USnider Scott E DBA · Turner, MTBuilt 1992 · S/N 402-0849 N152ALN152al LLC · Tulsa, OKBuilt 2004 · S/N 4697182 N1531GWoodley Aerial Leasing LLC · Walnut, ILBuilt 1992 · S/N 402-0850 N1531SWakefield Aircraft LLC · Cooperstown, NDBuilt 1991 · S/N 802-0002 N1533SMj Aviation Inc · Walnut Ridge, ARBuilt 1991 · S/N 402-0847 N1539XRba LLC · Kimberly, IDBuilt 1992 · S/N 502A-0166 N153GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-153 N153PBCarojake LLC · Spartanburg, SCBuilt 1996 · S/N 153 N1540SArthur Aviation LLC · Arthur, NDBuilt 1992 · S/N 502-0171 N1544VGuardian Flight LLC · Lewisville, TXBuilt 1994 · S/N LJ-1366 N1547UR & D Leasing Inc · Lemoore, CABuilt 1992 · S/N 502A-0183 N154CAFedair Inc · Indianapolis, INBuilt 1980 · S/N 31T-8020085 N154GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-154 N1552DDodson International Parts Inc · Rantoul, KSBuilt 1989 · S/N LJ-1204 N1552GEast Atlantic Aviation LLC · Edenton, NCBuilt 1989 · S/N LJ-1206 N1553GMccloy Mark · Tatum, NMBuilt 1989 · S/N LJ-1214 N1556WPrecissi Flying Service Inc · Lodi, CABuilt 1992 · S/N 502-0185 N15570Shearer Sprayers Inc · The Dalles, ORBuilt 1992 · S/N 402-0884 N15588Slikker Flying Service Inc · Buttonwillow, CABuilt 1992 · S/N 502A-0175 N1558URba LLC · Kimberly, IDBuilt 1992 · S/N 502A-0188 N155CJUe-55 LLC · Helena, MTS/N UE-55 N155CLAircraft Structures International Corp · Enid, OKBuilt 1988 · S/N 208B0127 N155MCWhite Bay Aviation LLC · Corpus Christi, TXBuilt 1978 · S/N 31T-7820069 N155SYRocky Mountain Aviation LLC · Aberdeen, IDBuilt 1992 · S/N 1013 N157HJaars Inc · Waxhaw, NCBuilt 2020 · S/N 20800668 N157LAWakefield Aircraft LLC · Cooperstown, NDBuilt 2003 · S/N 802A-0157 N157MHMile Hi Skydivers Inc · Longmont, COS/N LW157 N157STAllen Family Aviation LLC · Haines, ORBuilt 2023 · S/N 4698280 N158CLUnited States Government · Fort Belvoir, VABuilt 1981 · S/N 58 N159CMMomentum Foundation Inc · Tullahoma, TNBuilt 1987 · S/N 760333 N160RWRitch Air LLC · Visalia, CABuilt 1998 · S/N FL-226 N160SMAviation Star S LLC · Beaumont, TXBuilt 1998 · S/N FL-215 N162GAPa1 208b-0667 LLC · Fort Lauderdale, FLBuilt 1998 · S/N 208B0667

Back to AD 2014-17-08 R1