OpenAirDocs.org
AD 2017-19-15

Registered aircraft · 78

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-19-15')
    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-19-15')
  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.

N108LUMidwest Corporate Air Inc · Bellefontaine, OHBuilt 2007 · S/N 42.307N127USN127us LLC · Merrimack, NHS/N 42.AC127N16ESMeow Meow LLC · Seattle, WABuilt 2007 · S/N 42.AC100N188KUOak Street Properties LLC · Pratt, KSBuilt 2006 · S/N 42.AC020N205TDB&R Mcclure Limited Family Partnership · Panama City, FLBuilt 2015 · S/N 7429N228USAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2008 · S/N 42.347N232DXPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010032N238USMeow Meow LLC · Seattle, WABuilt 2008 · S/N 42.AC128N252DXGlobe Aero LLC · Lakeland, FLBuilt 2026 · S/N 28010033N253DXGlobe Aero LLC · Lakeland, FLBuilt 2026 · S/N 28010034N254DXGlobe Aero LLC · Lakeland, FLBuilt 2026 · S/N 28010035N265CCInternational Air Services Inc Trustee · Carson City, NVS/N 42.AC102N268DXPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010068N269DXPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010069N274DXGlobe Aero LLC · Lakeland, FLBuilt 2026 · S/N 28010074N276DXGlobe Aero LLC · Lakeland, FLBuilt 2026 · S/N 28010076N277DXGlobe Aero LLC · Lakeland, FLBuilt 2026 · S/N 28010077N361GSGulf 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.056N384GSMabav LLC · Mooresville, NCBuilt 2006 · S/N 42.104N42TBest Diamond 2 LLC · N Canton, OHBuilt 2007 · S/N 42.AC084N441AGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1983 · S/N 17276091N460LDTactical Integrated Training Solutions LLC · Colorado Springs, COBuilt 2007 · S/N 42.AC066N461PANichols Aviation LLC · Seattle, WABuilt 2007 · S/N 42.AC087N465ASSequoia Insight LLC · Houston, TXBuilt 2007 · S/N 42.AC065N469WWMx Jets Inc Trustee · Carson City, NVBuilt 2007 · S/N 42.AC074N472DXGlobe Aero LLC · Lakeland, FLBuilt 2026 · S/N 28010072N473DXGlobe Aero LLC · Lakeland, FLBuilt 2026 · S/N 28010073N480TSAnodyne Of Savannah LLC · Newark, DEBuilt 2007 · S/N 42.AC080N482TSSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2007 · S/N 42.AC082N483TSDouble Diamond Aviation LLC · Greenbrier, TNBuilt 2007 · S/N 42.AC083N485AGDiamond Aircraft Sales Of Kentucky LLC · Henderson, KYBuilt 2007 · S/N 42.AC085N48DSEydon LLC · Boca Grande, FLBuilt 2007 · S/N 42.AC070N490AGFxe Flightcenter Corp · Fort Lauderdale, FLNon-citizen corporation, flight hours not reportedBuilt 2005 · S/N 42.112N490TSVories Dennis L Pe · College Place, WABuilt 2007 · S/N 42.AC090N491TSCarter Stephen S Trustee · Rancho Santa Fe, CABuilt 2007 · S/N 42.AC091N496TSDiamond 777 LLC · Chestnut Ridge, NYBuilt 2007 · S/N 42.AC096N499BKAero Leasing Inc · Redding, CABuilt 2007 · S/N 42.AC099N503TSCox Aviation LLC · Portsmouth, RIBuilt 2007 · S/N 42.AC103N506SKFlight Stars Az LLC · Tempe, AZBuilt 2007 · S/N 42.AC092N508PAAlpha Leasing LLC · Daytona Beach, FLBuilt 2007 · S/N 42.AC079N56KDDiamond Aircraft Sales Of Kentucky LLC · Henderson, KYBuilt 2007 · S/N 42.AC076N607PADolphin Leasing LLC · Daytona Beach, FLBuilt 2007 · S/N 42.AC078N612TDDriftwood Aviation LLC · Northport, MIBuilt 2014 · S/N 7392N614ZMTwin Eagles Aviation LLC · High Point, NCBuilt 2007 · S/N 42.AC113N638AKFlyshure LLC · Minneapolis, MNBuilt 2006 · S/N 42.146N648KMValiair Lc Trustee · Casper, WYBuilt 2007 · S/N 42.316N702RFNovember Tango LLC · Richmond, VABuilt 2007 · S/N 42.AC109N70DXGlobe Aero LLC · Lakeland, FLBuilt 2026 · S/N 28010070
Back to AD 2017-19-15