Skip to content

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

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.

N5034RMid Missouri Spray Service LLC · Richmond, MOBuilt 1996 · S/N 402B-1020 N5035KAmberican Aviation Inc · Grand Forks, NDBuilt 1997 · S/N 802-0048 N50383Sky Apply LLC · Hector, MNBuilt 1998 · S/N 502B-0493 N5039FDixie Flying Service Inc · Gilliam, LABuilt 1997 · S/N 402A-1031 N5039JDavis Blake · Bellevue, TXBuilt 1997 · S/N 502B-0454 N503AWCsi Aviation Inc · Albuquerque, NMBuilt 1995 · S/N BB-1514 N503LMBig Sky LLC · Draper, UTBuilt 1997 · S/N FL-182 N5044NGrowers Air Service Inc · Woodland, CABuilt 1997 · S/N 502B-0452 N5046FMulder Air Inc · Renville, MNBuilt 1997 · S/N 502B-0455 N5048SBob Ruhe Ag Service LLC · Leipsic, OHBuilt 1998 · S/N 502B-0495 N504DDDigger Doug'S Crop Dusting Service Inc · Hollandale, WIBuilt 2022 · S/N 504-4042 N504HPFlorida Highway Patrol · Tampa, FLBuilt 2003 · S/N 514 N5059JTanner Flying Service Inc · Cortez, COBuilt 1997 · S/N 402B-1039 N5059VKross Lessyn Aerial Inc · Hereford, TXBuilt 1998 · S/N 402B-1066 N505PAutomotive Specialist LLC · Hopkins, MNBuilt 2003 · S/N 505 N50623Redtail Inc · Wakarusa, INBuilt 1997 · S/N 502B-0458 N5063NSale Reported · Prattville, ALSale reportedBuilt 1997 · S/N 502B-0471 N50648Lindsey Aviation Services · Haslet, TXBuilt 1990 · S/N 20800191 N5066CFarm Ag Enterprises LLC · Buckeye, AZBuilt 1997 · S/N 802A-0045 N506MVFirecracker Air LLC · Missoula, MTBuilt 1999 · S/N FL-261 N5075LAslesen Leasin LLC · Halstad, MNBuilt 1998 · S/N 502B-0480 N5075PPeterson Tony D · Humboldt, IABuilt 1997 · S/N 502B-0439 N50761Arthur Aviation LLC · Arthur, NDBuilt 1998 · S/N 402A-1065 N507RCDodson International Parts Inc · Rantoul, KSBuilt 2003 · S/N 507 N5085QScl Aviators · Wilmington, DEBuilt 1997 · S/N 402B-1047 N50877Arrow Aviation Inc · Broken Bow, NEBuilt 1997 · S/N 502B-0472 N508BHCity Of Anaheim · Fullerton, CABuilt 2012 · S/N 208B2380 N508RJBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 20800315 N5091HLake Air Service LLC · Jennings, LABuilt 1997 · S/N 602-0444 N5091NFarm Air Flying Service LLC · Sacramento, CABuilt 1997 · S/N 502B-0475 N50927Prairie Ag Service LLC · Des Arc, ARBuilt 1997 · S/N 402A-1041 N5092GSteinke Matthew · Gibson, IABuilt 1998 · S/N 502B-0515 N5094HWoodley Aerial Leasing LLC · Walnut, ILBuilt 1998 · S/N 802A-0067 N509JETwo Percent Aviation LLC · Lewes, DEBuilt 2009 · S/N 20800509 N509JJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 4698223 N50BRBartholow Rental Company Inc · Wylie, TXBuilt 2001 · S/N LJ-1632 N50FKFirecracker Inc · Eugene, ORBuilt 1984 · S/N 006 N50GGN50gg Leasing LLC · Ponca City, OKBuilt 2000 · S/N BB-1728 N50KAKenmore Air Harbor LLC · Kenmore, WABuilt 1956 · S/N 221 N50NABv Transportation LLC · Portland, ORBuilt 1995 · S/N BB1504 N5100DTall Towers Aviation Inc · Page, NDBuilt 1997 · S/N 502B0412 N51019Lohmann Jack R · Frisco, COBuilt 2000 · S/N 4697008 N5102AThrush Aircraft LLC · Albany, GABuilt 2020 · S/N T34-503 N5109HAlexander Ag Flying Service Inc · Walnut Grove, CABuilt 1997 · S/N 502B-0460 N510GSAmdel Holding LLC · Houston, TXBuilt 2001 · S/N BB-1746 N5110SChoctaw Flying Service Inc · Inverness, MSBuilt 1997 · S/N 402A-1043 N5110ZPonderosa Airtankers LLC · Safford, AZBuilt 1998 · S/N 802A-0060 N5111PDe La Vega Artemio · Dallas, TXBuilt 1986 · S/N LJ-1136 N5119GTri-Air Farms LLC · Mamou, LABuilt 1997 · S/N 502B-0474 N511KVDelta Fox LLC · Woodland, CABuilt 1995 · S/N LJ1422

Back to AD 2014-17-08 R1