OpenAirDocs.org
AD 2016-05-13

Registered aircraft · 3,126

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:2016-05-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-05-13')
  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.

N502FATaylors 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-0532N5034RMid Missouri Spray Service LLC · Richmond, MOBuilt 1996 · S/N 402B-1020N5035KAmberican Aviation Inc · Grand Forks, NDBuilt 1997 · S/N 802-0048N50383Sky Apply LLC · Hector, MNBuilt 1998 · S/N 502B-0493N5039FDixie Flying Service Inc · Gilliam, LABuilt 1997 · S/N 402A-1031N5039JDavis Blake · Bellevue, TXBuilt 1997 · S/N 502B-0454N503AWCsi Aviation Inc · Albuquerque, NMBuilt 1995 · S/N BB-1514N503FAMccaleb'S Flying Service LLC · Plaucheville, LABuilt 2013 · S/N 802A-0503N503LMBig Sky LLC · Draper, UTBuilt 1997 · S/N FL-182N5044NGrowers Air Service Inc · Woodland, CABuilt 1997 · S/N 502B-0452N5046FMulder Air Inc · Renville, MNBuilt 1997 · S/N 502B-0455N5048SBob Ruhe Ag Service LLC · Leipsic, OHBuilt 1998 · S/N 502B-0495N504DDDigger Doug'S Crop Dusting Service Inc · Hollandale, WIBuilt 2022 · S/N 504-4042N504HPFlorida Highway Patrol · Tampa, FLBuilt 2003 · S/N 514N5059JTanner Flying Service Inc · Cortez, COBuilt 1997 · S/N 402B-1039N5059VKross Lessyn Aerial Inc · Hereford, TXBuilt 1998 · S/N 402B-1066N505FAAir Cover Crop Solutions LLC · Frankford, MOBuilt 2013 · S/N 802A-0505N505PAutomotive Specialist LLC · Hopkins, MNBuilt 2003 · S/N 505N50623Redtail Inc · Wakarusa, INBuilt 1997 · S/N 502B-0458N5063NSale Reported · Prattville, ALSale reportedBuilt 1997 · S/N 502B-0471N50648Lindsey Aviation Services · Haslet, TXBuilt 1990 · S/N 20800191N5066CFarm Ag Enterprises LLC · Buckeye, AZBuilt 1997 · S/N 802A-0045N506FAPontiac Flying LLC · Pontiac, ILBuilt 2014 · S/N 802A-0572N506MVFirecracker Air LLC · Missoula, MTBuilt 1999 · S/N FL-261N5075LAslesen Leasin LLC · Halstad, MNBuilt 1998 · S/N 502B-0480N5075PPeterson Tony D · Humboldt, IABuilt 1997 · S/N 502B-0439N50761Arthur Aviation LLC · Arthur, NDBuilt 1998 · S/N 402A-1065N507FAGarrett Flying Service Inc · Danbury, TXBuilt 2014 · S/N 602-1247N507GFBallard Aviation Inc · Newton, KSBuilt 2001 · S/N BB-1778N507RCDodson International Parts Inc · Rantoul, KSBuilt 2003 · S/N 507N5085QScl Aviators · Wilmington, DEBuilt 1997 · S/N 402B-1047N50877Arrow Aviation Inc · Broken Bow, NEBuilt 1997 · S/N 502B-0472N508DGOld River Flying Service LLC · Wabash, ARBuilt 2013 · S/N 802A-0499N508RJBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 20800315N508SKMagnolia Logistics Of Ms LLC · Flowood, MSBuilt 1985 · S/N FA-78N5091HLake Air Service LLC · Jennings, LABuilt 1997 · S/N 602-0444N5091NFarm Air Flying Service LLC · Sacramento, CABuilt 1997 · S/N 502B-0475N50927Prairie Ag Service LLC · Des Arc, ARBuilt 1997 · S/N 402A-1041N5092GSteinke Matthew · Gibson, IABuilt 1998 · S/N 502B-0515N5094HWoodley Aerial Leasing LLC · Walnut, ILBuilt 1998 · S/N 802A-0067N509JJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 4698223
Back to AD 2016-05-13