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.

N426EMBank Of Utah Trustee · Salt Lake City, UTBuilt 1993 · S/N LJ-1352 N426KMKenmore Air Harbor LLC · Kenmore, WABuilt 1999 · S/N 20800306 N427CTuffy LLC · Fremont, NEBuilt 1995 · S/N 102 N427DDYunus Asim · Saginaw, MIBuilt 1978 · S/N 31T-7820029 N427DMSky Charter LLC · Slidell, LABuilt 1979 · S/N LJ804 N427JSLiechty Automotive Management LLC · Gulf Breeze, FLBuilt 1999 · S/N FL-263 N427NSVisser Ag Inc · Rigby, IDBuilt 2003 · S/N 802A-0153 N427TAAircraft Properties LLC · Hampstead, NCBuilt 1977 · S/N 31T-7720027 N42FCN42fc Leasing LLC · Ponca City, OKBuilt 1996 · S/N BB-1553 N42ZDynamic Avlease Inc · Bridgewater, VABuilt 1976 · S/N BC28 N430TXTexas Department Of Public Safety · Austin, TXBuilt 2021 · S/N 20800682 N431ZTZimin Transportation LLC · South Naknek, AKBuilt 1976 · S/N BC-18 N432WAWoodley Aerial Leasing LLC · Walnut, ILS/N 400-0435 N4350JPhoenix Equipment Lc · Nickerson, KSBuilt 1982 · S/N 400A-0463 N435MTSouthwest Aviation Solutions LLC · Las Vegas, NVBuilt 2007 · S/N 208B1305 N4365UWright Air Service Inc · Fairbanks, AKBuilt 1991 · S/N 208B0253 N436EAN436ea LLC · Sanford, FLBuilt 1997 · S/N BB-1576 N437WFHewitson Enterprises Inc · Avenal, CABuilt 1981 · S/N BB-962 N438CRKilo Alpha 438 LLC · Edgewater, FLBuilt 1978 · S/N BB438 N43BGRight Brothers LLC · San Clemente, CABuilt 1994 · S/N FL-117 N43CW42f LLC · Key West, FLBuilt 1990 · S/N 20800175 N43VMN43vm LLC · Fremont, CABuilt 2000 · S/N 46-97005 N43WAWhatever Aviation LLC · Olympia, WABuilt 1970 · S/N LJ-501 N43WHLaurel Malibu LLC · Windber, PABuilt 1982 · S/N 31T-8120068 N440CACc Flight Company LLC · Columbia City, INBuilt 1985 · S/N 42-5501027 N4415FB&G Air Inc · Morgan City, LABuilt 2002 · S/N LJ-1675 N442DSSantori Aviation LLC · Helena, MTBuilt 1994 · S/N 96 N444ASAas LLC · Ovid, MIBuilt 1982 · S/N 400-0438 N444CMDl Aviation Solutions LLC · Jacksonville, FLBuilt 1996 · S/N 152 N444HFJohnson Airspray Inc · Argyle, MNBuilt 1992 · S/N T36-191 N444WGSchmucker Real Estate Holdings Lp · Wilmington, DEBuilt 1981 · S/N 31T-8166054 N445LLMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2023 · S/N K045 N445MSAas LLC · Ovid, MIBuilt 1994 · S/N 502B-0237 N4476FTrans Executive Airlines Of Hawaii Inc · Honolulu, HIBuilt 1987 · S/N SH3731 N447DBGuardian Flight LLC · Lewisville, TXBuilt 2001 · S/N LJ-1656 N4488LSouth Texas Aviation Inc · Wilmington, DEBuilt 1995 · S/N LJ-1423 N449CACharlie Alpha LLC · Ketchum, IDBuilt 1999 · S/N 150 N44KAHunter Aviation Of Tampa LLC · Saint Petersburg, FLBuilt 2000 · S/N BB-1711 N45123Wood Flying Inc · Panhandle, TXS/N 402-0753 N45196Boettcher Aerial Inc · Beloit, KSS/N 402-0755 N4523LWiebe Albert · Seminole, TXS/N 402-0757 N4527XSug-Air LLC · Lubbock, TXS/N 402A-0758 N4528LSkyworks Aviation LLC · Waynesboro, GAS/N 402A-0759 N452GHCrescent Real Estate Investors LLC · Park City, UTBuilt 2005 · S/N 628 N45363South Delta Aviation Inc · West Helena, ARS/N 402-0774 N45368Atlantic Ag Aviation Inc · Felton, DEBuilt 1990 · S/N 401-0775 N4539BWoodley Aerial Leasing LLC · Walnut, ILBuilt 1990 · S/N 401-0763 N4540FWoodley Aerial Leasing LLC · Walnut, ILBuilt 1990 · S/N 402-0784 N4540YTlc Flying Inc · Colfax, WABuilt 1990 · S/N 502-0120 N4541SKankakee Valley Aviation LLC · Wanatah, INS/N 402-0778

Back to AD 2014-17-08 R1