OpenAirDocs.org
AD 2014-17-08 R1

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

N48APBer Tanglewood Holdings LLC · Amarillo, TXBuilt 1999 · S/N LJ-1548N491JVCessna 205 LLC · Austin, TXBuilt 1993 · S/N LJ-1349N491SCSouthern Cross Aircraft LLC · Fort Lauderdale, FLBuilt 2002 · S/N 235N4920YWindsock Aviation LLC · Old Saybrook, CTBuilt 2000 · S/N 169N492KKatmai Air LLC · Anchorage, AKBuilt 1957 · S/N 1185N494MAKing Lenny LLC · Fairview Park, OHBuilt 1986 · S/N FA108N497GATri-State Aerial LLC · Canton, SDBuilt 1984 · S/N 400A-0502N497PCUS Department Of Homeland Security · Washington, DCBuilt 2003 · S/N 497N498GGPleasant Aircraft Leasing LLC · Newbury Park, CABuilt 2009 · S/N 208B2118N499CZN499cz LLC · Milwaukee, WIBuilt 1969 · S/N U-81N49BTFlight Levels LLC · Ridgeland, MSBuilt 2003 · S/N 4697161N49GM3-J Air LLC · Miami, OKBuilt 1982 · S/N 425-0165N49HFStanley Jason · Georgetown, TXBuilt 1988 · S/N 46-08125N49JPSumner Properties LLC · Somersworth, NHBuilt 1990 · S/N LJ1243N49RDynamic Avlease Inc · Bridgewater, VABuilt 1975 · S/N BD02N49TWMulton Nutritional Services Inc · Kearney, NEBuilt 2023 · S/N 4698288N49WCWest Coast Aircraft Shares LLC · Santa Ana, CABuilt 1996 · S/N FL-144N5001LAcme Aerial Application LLC · Seneca Falls, NYBuilt 1998 · S/N 502B-0513N5002JBcs Aerial LLC · Butler, MOBuilt 1998 · S/N 502B-0498N5002WSouther Crop Spraying Inc · Douglas, GABuilt 1997 · S/N 802A-0038N5003CCrop Air LLC · Eaton, COS/N 502B-0396N5004VTim Whitfield Aviation Inc · Fairfield, NCBuilt 1996 · S/N 502B-0400N5006KWoods Aviation LLC · Kearney, NEBuilt 1997 · S/N 402B-1024N50071South Delta Aviation Inc · West Helena, ARBuilt 1996 · S/N 402B-1019N5007GWesterlin Harrington Flying Service Inc · Holdrege, NEBuilt 1997 · S/N 502B-0417N5008LOlathe Spray Service Inc · Olathe, COBuilt 1996 · S/N 402B-1018N5009SBrignac Flying Service LLC · Columbus, MSBuilt 1996 · S/N 502B-0402N500EQTxsd Holdings LLC · Amarillo, TXBuilt 1994 · S/N LJ-1387N500HAWandering Quarks LLC · Lincolnville, MEBuilt 2005 · S/N 4697222N500JM500jm Aviation LLC · Westfield, INBuilt 2001 · S/N 4697118N500SEPjh Consulting LLC · Reno, NVBuilt 1994 · S/N FL125N5010JGc Aviation LLC · Kalispell, MTBuilt 1997 · S/N 502B-0419N5012CVan Namen Jonathan E · Benoit, MSBuilt 1997 · S/N 502B0411N5018JRegistration Pending · Littlefield, TXRegistration pending, pending cancellationBuilt 1997 · S/N 502B-0432N5019AReabe Spraying Service Inc · Plover, WIBuilt 1997 · S/N 502B-0415N5019YAir Sprayers Inc · Two Buttes, COS/N 402A-1071N501DUWaterside Holdings LLC · Knoxville, TNBuilt 1980 · S/N LA-82N501HKBam Aviation LLC · Baton Rouge, LABuilt 1979 · S/N BB-565N5022CCleveland Air Service Inc · Cleveland, MSBuilt 1998 · S/N 502B-0479N50256Panola Flying Service LLC · Lake Providence, LABuilt 1998 · S/N 402A-1059N502FATaylors Flying Service Inc · Utica, MSBuilt 1993 · S/N 502-0217N502JAHoppe Air LLC · Beaman, IABuilt 1992 · S/N 502-0169N502JKRoma Air Corp · Belle Glade, FLBuilt 1996 · S/N 502B-0373N502JWBear Flying Service Inc · Sicily Island, LABuilt 1992 · S/N 502-0163N502MKGeist Daniel C · Crookston, MNBuilt 1996 · S/N 502B-0356N502NJBretts Spray Service Inc · Onida, SDBuilt 1991 · S/N 502-0138N502QDixie Flying Service Inc · Gilliam, LABuilt 1999 · S/N 502B-0573N502TGOld River Applicators LLC · Simmesport, LABuilt 1999 · S/N 502B-0538N502TRSterling John A · Port Lavaca, TXBuilt 1999 · S/N 502B-0553N502XXRobinson Reid · Hollis, OKBuilt 1998 · S/N 502B-0532
Back to AD 2014-17-08 R1