OpenAirDocs.org
AD 2017-11-08

Registered aircraft · 114

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

N101DAFlying High Again LLC · Mount Juliet, TNBuilt 2006 · S/N 42.125N108LUMidwest Corporate Air Inc · Bellefontaine, OHBuilt 2007 · S/N 42.307N119BJFlight Stars Az LLC · Tempe, AZBuilt 2007 · S/N 42.AC045N127USN127us LLC · Merrimack, NHS/N 42.AC127N132TSUtah State University · Logan, UTBuilt 2006 · S/N 42.AC018N149WTVectors To Final LLC · Columbus, OHBuilt 2007 · S/N 42.AC046N158TSMidwest Corporate Air Inc · Bellefontine, OHBuilt 2006 · S/N 42.137N16ESMeow Meow LLC · Seattle, WABuilt 2007 · S/N 42.AC100N16FAAv8 Flight Assets LLC · Eden Prairie, MNBuilt 2007 · S/N 42.AC029N176TSOld Glory Inc · Tulsa, OKBuilt 2006 · S/N 42.176N188KUOak Street Properties LLC · Pratt, KSBuilt 2006 · S/N 42.AC020N189YCerrit LLC · Helena, MTBuilt 2006 · S/N 42.AC033N197TSTango Charlie Foxtrot LLC · Port Orange, FLBuilt 2006 · S/N 42.AC001N198TSWorld Class Aviation Ltd · Bellefontaine, OHBuilt 2006 · S/N 42.AC002N199TSWind Rising Ventures LLC · Columbus, MSBuilt 2006 · S/N 42.AC003N213WJDiamond N213wj Inc · Coral Gables, FLS/N 42.AC053N215BNMidwest Corporate Air Inc · Bellefontaine, OHBuilt 2007 · S/N 42.AC055N226DSDelta State University · Cleveland, MSBuilt 2011 · S/N 42.AC137N228USAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2008 · S/N 42.347N236TSFisher Curtis R · Mankato, MNBuilt 2006 · S/N 42.AC022N237TT42.Ac037 Inc Trustee · Wilmington, DES/N 42.AC037N238USMeow Meow LLC · Seattle, WABuilt 2008 · S/N 42.AC128N240TSUtah State University · Logan, UTBuilt 2005 · S/N 42.072N242DPFlying High Again LLC · Mount Juliet, TNBuilt 2006 · S/N 42.AC032N243TSJoerithan & Mp Aviation LLC · Whittier, CABuilt 2007 · S/N 42.AC043N265CCInternational Air Services Inc Trustee · Carson City, NVS/N 42.AC102N27SJ0x1b LLC · Brooklyn, NYBuilt 2006 · S/N 42.AC014N316MZBecerra George C · Northridge, CABuilt 2007 · S/N 42.AC054N327TSTransport Services LLC · Little Rock, ARBuilt 2006 · S/N 42.AC027N328TSMidwest Corporate Air Inc · Bellefontaine, OHBuilt 2006 · S/N 42.AC028N350TSUtah State University · Logan, UTBuilt 2005 · S/N 42.061N35ALTriple M Aviation Inc Trustee · Wilmington, DEBuilt 2006 · S/N 42.147N361GSGulf States Aircraft Sales LLC · Crossville, TNBuilt 2005 · S/N 42.101N368TSRegistered aircraftBuilt 2008 · S/N 42.AC124N37VKHighsky Aero Inc · Arlington, TXBuilt 2005 · S/N 42.056N383GSGulf States Aircraft Sales LLC · Crossville, TNS/N 42.103N384GSMabav LLC · Mooresville, NCBuilt 2006 · S/N 42.104N388DSDelta State University · Cleveland, MSBuilt 2011 · S/N 42.AC139N408SATake Flight Aviation LLC · Montgomery, NYBuilt 2007 · S/N 42.AC047N415TSBeta Fleet LLC · South Burlington, VTBuilt 2006 · S/N 42.AC015N417TSNymoon LLC · San Juan Capo, CABuilt 2006 · S/N 42.AC017N4197DAir Shares LLC · Casper, WYBuilt 2007 · S/N 42.AC086N422GLSummit Aviation Inc · Belgrade, MTBuilt 2007 · S/N 42.AC050N424AMSkywarrior Flight Training LLC · Pensacola, FLBuilt 2006 · S/N 42.AC024N424RPFlight Stars Az LLC · Mesa, AZBuilt 2007 · S/N 42.AC039N429TPSkywest Leasing Inc · St George, UTBuilt 2005 · S/N 42.090N42TBest Diamond 2 LLC · N Canton, OHBuilt 2007 · S/N 42.AC084N42YJSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 42.135N430PSMiller Air LLC · Portland, ORBuilt 2006 · S/N 42.066N430TSWateractive43 LLC · Auburn, CABuilt 2006 · S/N 42.AC030
Back to AD 2017-11-08