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.

N3066NBoair Inc · Shaw, MSBuilt 2014 · S/N 602-1241N3066WFortis Aircraft Leasing LLC · Reno, NVBuilt 1998 · S/N LJ-1536N30674Jlw Aviation Inc · Carlisle, ARBuilt 2014 · S/N 802A-0557N30676Michaelis Gary DBA · Goodwin, ARBuilt 2014 · S/N 802A-0573N3067JHartley Flying Service Inc · Stuttgart, ARBuilt 2014 · S/N 802A-0554N3068BMccreary Flying Service LLC · Clarksdale, MSBuilt 2014 · S/N 602-1248N3069SRoma Air Corp · Belle Glade, FLBuilt 2014 · S/N 802A-0559N3070FDakota Air Spray LLC · Huron, SDBuilt 2014 · S/N 802A-0577N3070N49 Flying Service LLC · Greenwood, MSBuilt 2014 · S/N 602-1250N30757Moses Lake-Warden Air Service Inc · Moses Lake, WABuilt 2013 · S/N 802A-0534N3079DNesom Waddell Cole · New Roads, LABuilt 2015 · S/N 602-1260N307BRRice Flying LLC · Poplar Bluff, MOFirst renewal noticeBuilt 2017 · S/N 802-0718N307SBSan Bernardino County Sheriffs Aviation Division · San Bernardino, CABuilt 1975 · S/N 30781N3080FGreyhawk Aviation LLC · Ketchum, IDBuilt 1999 · S/N FL-249N3082PCustom Air Inc · Roe, ARBuilt 2015 · S/N 802A-0600N3082VMid Missouri Spray Service LLC · Richmond, MOBuilt 2015 · S/N 802A-0620N3083KBoyds Aviation LLC · Rayville, LABuilt 2015 · S/N 802A-0618N3086AArrow Aviation Inc · Broken Bow, NEBuilt 2015 · S/N 802A-0616N3087KBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 602-1264N30898Painter Andrew S · Harlingen, TXBuilt 2005 · S/N 4697202N308CSTvpx 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 4697189N309PFPalmer Flying Service Inc · Manito, ILBuilt 2025 · S/N 802A-1213N30BEEllingson 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-156N3105EJohnson Airspray Inc · Argyle, MNBuilt 1992 · S/N T34-177N31062Central Virginia Aviation Inc · Petersburg, VABuilt 2005 · S/N 4697208N310JKConnors Air Holdings LLC · Tierra Verde, FLBuilt 2001 · S/N 4697069N310KPLowry Flying Service Inc · Grinnell, IABuilt 2013 · S/N 602-1232N3110TWellborn 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-55N311MJVacuum Industrial Pollution International Inc · Baton Rouge, LABuilt 1991 · S/N FL-51N311MXInternational Air Services Inc Trustee · Carson City, NVBuilt 2022 · S/N 4698213N312BCWorldwide Option LLC · Lewes, DEBuilt 1994 · S/N 101N312FBFarm Brothers Flyers A LLC · Gould, ARBuilt 2020 · S/N 602-1312N312RLNyati Worldwide LLC · Sinton, TXBuilt 1997 · S/N FL-164N313DWDurair Inc · Key West, FLBuilt 1996 · S/N LJ-1434N313FAAg Air Flying Service Inc · Toppenish, WABuilt 2016 · S/N 802A-0655N313HAValiair Lc Trustee · Casper, WYBuilt 1993 · S/N FL-96N314AWUS Government · Washington, DCBuilt 2004 · S/N FL-387N315AWUS Government · Washington, DCBuilt 1992 · S/N FL-91
Back to AD 2016-05-13