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.

N40SBSan Bernadino County Sheriffs Office · San Bernardino, CABuilt 1976 · S/N BD-09 N40TTHeiderscheidt Aerial LLC · Sleepy Eye, MNBuilt 1975 · S/N 31T-7520023 N410GVPa1 208b-0632 LLC · Fort Lauderdale, FLBuilt 1997 · S/N 208B0632 N4118KSouthern Airways Pacific LLC · Addison, TXBuilt 2007 · S/N 208B1283 N411CCSunshine Aviation LLC · Roseburg, ORS/N BB-1520 N411GCWb Air2021 LLC · Cochran, GABuilt 1997 · S/N FL163 N411GVPa1 208b-0672 LLC · Fort Lauderdale, FLBuilt 1998 · S/N 208B0672 N411JPBluffside Aero LLC · Williamsburg, VABuilt 2022 · S/N 4698229 N411RSm1019 LLC · Polson, MTBuilt 2006 · S/N 4697241 N412TFBig Grand Aviation LLC · Jupiter, FLBuilt 2018 · S/N 20800611 N413AFBerry Genetics Inc · Portsmouth, NHBuilt 2024 · S/N 2413 N414GJRegistered aircraftBuilt 1991 · S/N 20 N415TMCrouch Aire LLC · Westcliffe, COS/N BB-1762 N415TTT & T Capital Inc · Bangor, MEBuilt 1993 · S/N 208B0365 N416DFUsda Forest Service · Mcclellan, CABuilt 1985 · S/N BL-124 N4174VDalmore Estates LLC · Los Angeles, CABuilt 2000 · S/N 4697014 N41783Fpg Agri Services LLC · Frost, TXBuilt 1987 · S/N T-34-092DC N417ARGreenway Air LLC · Orlando, FLS/N 611 N417KCFeatherstone Two LLC · Tampa, FLBuilt 2001 · S/N 417 N4185LWdw Aviation Leasing Inc · Knoxville, TNBuilt 2000 · S/N 4697025 N418JCsk Aviation Partners LLC · Fort Smith, ARBuilt 2000 · S/N BB-1705 N4191YPake Flying Service LLC · Felton, MNBuilt 2000 · S/N T660-108 N419FFMccreary Flying Service LLC · Clarksdale, MSS/N 802A-0191 N419MNSouthern Justice Aviation LLC · Houston, TXBuilt 1980 · S/N BB-785 N41MKEric Leasing LLC · London, KYBuilt 2023 · S/N 4698247 N420DZDesert Sand Aircraft Leasing Co Inc · Rosharon, TXBuilt 2001 · S/N 208B0909 N420SAKingrey William S III · Richmond, TXBuilt 1990 · S/N 402-0776 N4222ATenax Air LLC · Ridgeland, MSBuilt 2001 · S/N UE-422 N423MGMike Gulf LLC · Fort Lauderdale, FLBuilt 1996 · S/N 140 N424AGDancing On A Dream Inc Trustee · Wilmington, DEBuilt 2008 · S/N 208B2013 N424EMDale Aviation Inc · Rapid City, SDBuilt 1993 · S/N LJ-1351 N424SGAt Holdco LLC · San Antonio, TXBuilt 2001 · S/N 4697039 N425BAMarchetti 211 LLC · Alva, OKS/N 4250046 N425BPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N BB-1773 N425CQHeritage On Lanier Inc · Gainesville, GABuilt 1983 · S/N 425-0173 N425DRAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1984 · S/N 4250199 N425EMVfr Air LLC · Tifton, GABuilt 1982 · S/N 425-0164 N425HJApd Development LLC · Palatine, ILBuilt 1984 · S/N 425-0169 N425KCWheels Up Aviation LLC · Mount Horeb, WIBuilt 1982 · S/N 425-0174 N425LCGlyde Aviation LLC · Canton, MABuilt 1981 · S/N 4250054 N425NPGec Air LLC · Sellersburg, INBuilt 1985 · S/N 4250224 N425TPRc Construction Co · Greenwood, MSBuilt 1984 · S/N 425-0213 N425TVPaine Conquest I LLC · Redmond, WAS/N 425-0176 N425TXContinental Forwarding Services Inc · Laredo, TXBuilt 1981 · S/N 4250039 N425W4js LLC · Holland, MIBuilt 1978 · S/N LW268 N425WBBagdasarian Walter DBA · El Cajon, CAS/N 4250184 N425WDRegistered aircraftS/N 425-0130 N425WFRegistered aircraftAssigned, pending cancellationS/N 4250207 N425WLAirmann LLC · Mount Sterling, KYBuilt 1984 · S/N 4250197 N425XPK&M Aviation LLC · Aberdeen, SDBuilt 1981 · S/N 425-0064

Back to AD 2014-17-08 R1