OpenAirDocs.org
AD 2014-17-08 R1

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
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.

N307PRDog Is My Copilot Inc · Jackson, WYBuilt 1996 · S/N 208B0541N307SBSan Bernardino County Sheriffs Aviation Division · San Bernardino, CABuilt 1975 · S/N 30781N3080FGreyhawk Aviation LLC · Ketchum, IDBuilt 1999 · S/N FL-249N30898Painter Andrew S · Harlingen, TXBuilt 2005 · S/N 4697202N308ADC208b0327 Inc Trustee · Wilmington, DEBuilt 1992 · S/N 208B0327N308CSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1997 · S/N LJ-1478N308MDGem City Properties LLC · Laramie, WYBuilt 1990 · S/N LJ1246N308RMN308rm LLC · Boca Raton, FLBuilt 1974 · S/N LJ628N3096PV V I P LLC · Cottonwood, AZBuilt 2004 · S/N 4697178N3098365 Whiskey Romeo LLC · Timnath, COBuilt 2004 · S/N 4697189N30BEEllingson Craig Edward Trustee · Clive, IABuilt 2021 · S/N 4698194N30CCTalon Air Services Inc · Soldotna, AKBuilt 1964 · S/N 1566TB4N30EAEagle Air Transport Inc · Ottawa, ILBuilt 1968 · S/N 191N30HVCustom Fabricating & Repair Inc · Marshfield, WIBuilt 1989 · S/N FA-173N3104WBirch Tree Aviation LLC · Unadilla, GABuilt 1990 · S/N T34-151N3104YCrop Dusters LLC · Maurice, IABuilt 1991 · S/N T34-156N31062Central Virginia Aviation Inc · Petersburg, VABuilt 2005 · S/N 4697208N310JKConnors Air Holdings LLC · Tierra Verde, FLBuilt 2001 · S/N 4697069N3110TWellborn Aviation LLC · Texarkana, TXBuilt 2005 · S/N 4697221N3117SBlue Horseshoe LLC · Brentwood, TNBuilt 2005 · S/N 4697230N3117VP&C Aircraft LLC · Chapel Hill, NCBuilt 2005 · S/N 4697234N311GCRte Enterprises Inc · Canoga Park, CABuilt 1980 · S/N LA-55N311MXInternational Air Services Inc Trustee · Carson City, NVBuilt 2022 · S/N 4698213N312RLNyati Worldwide LLC · Sinton, TXBuilt 1997 · S/N FL-164N313DWDurair Inc · Key West, FLBuilt 1996 · S/N LJ-1434N313HAValiair Lc Trustee · Casper, WYBuilt 1993 · S/N FL-96N314AWUS Government · Washington, DCBuilt 2004 · S/N FL-387N315WSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1984 · S/N 425501015N316LVBayne Air LLC · Whitefish, MTBuilt 2025 · S/N K097N316PDLonghorn Air LLC · Wilmington, DEBuilt 2003 · S/N 14038N316PMAir Methods LLC · Greenwood Village, COBuilt 1998 · S/N 241N316PWAl Force 1 LLC · North Salt Lake, UTBuilt 1991 · S/N FM2N316WRHoxie Sprayers Inc · Hoxie, KSBuilt 1995 · S/N 502A-0316N31941Gasper Air Spray Inc · Crookston, MNBuilt 1995 · S/N T45-008N319PDAerotrust Services Corp Trustee · Wilmington, DEBuilt 2004 · S/N 14040N319TBShuck Holdings LLC · Anderson, SCBuilt 2005 · S/N 319N319WWWin Win Aviation Inc · Wake Forest, NCBuilt 1992 · S/N SH3209N31SASouthern Airways Pacific LLC · Addison, TXBuilt 2006 · S/N 208B1210N31TNLake Clark Air Inc · Port Alsworth, AKBuilt 1969 · S/N U49N31WDWestern Dakota Holding Co · Timber Lake, SDBuilt 1980 · S/N 425-0012N31XXTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1990 · S/N FL-31N3211RJohnson Airspray Inc · Argyle, MNBuilt 1978 · S/N 5100RN3216KSouth River Services LLC · Myrtle Beach, SCS/N LJ-1392N321CWBatte Bennie S · Forest, MSBuilt 1999 · S/N 155N321CYTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1968 · S/N 211N321FDynamic Avlease Inc · Bridgewater, VABuilt 1979 · S/N BC-70N321HXGggg LLC · Hilton Head Island, SCBuilt 1981 · S/N 425-0104N321PDynamic Avlease Inc · Bridgewater, VABuilt 1980 · S/N GR-10N3220LPee Dee Aviation LLC · Florence, SCBuilt 1995 · S/N LJ-1420N3221MGuardian Flight LLC · Lewisville, TXBuilt 2000 · S/N LJ-1621
Back to AD 2014-17-08 R1