OpenAirDocs.org
AD 2018-07-13

Registered aircraft · 967

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:2018-07-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:2018-07-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.

N652QSRegistered aircraftBuilt 2019 · S/N 680A0198N653QSRegistered aircraftBuilt 2019 · S/N 680A0199N659QSRegistered aircraftBuilt 2021 · S/N 680A0286N660HCDec LLC · Atlanta, GABuilt 2015 · S/N 680-0553N662BMMcvean Michael J · Flower Mound, TXBuilt 2012 · S/N 510-0408N662CCBlack Pearl Cessna 510 LLC · Springville, NYBuilt 2009 · S/N 510-0178N662QSRegistered aircraftBuilt 2021 · S/N 680A0274N664QSRegistered aircraftBuilt 2019 · S/N 680A0200N665QSRegistered aircraftBuilt 2019 · S/N 680A0201N665TRegistered aircraftBuilt 2016 · S/N 680A0065N667QSRegistered aircraftBuilt 2021 · S/N 680A0275N668QSRegistered aircraftS/N 680A0276N669BBJdhim-Xls LLC · Dallas, TXBuilt 2008 · S/N 680-0212N66DAlesia Holdings LLC · Beaumont, TXBuilt 2014 · S/N 5100454N66ESAvion 5 LLC · Houston, TXBuilt 2008 · S/N 510-0110N670QSRegistered aircraftBuilt 2019 · S/N 680A0205N671MDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 680-0524N671QSRegistered aircraftBuilt 2019 · S/N 680A0206N674QSRegistered aircraftBuilt 2019 · S/N 680A0207N675QSRegistered aircraftBuilt 2019 · S/N 680A0212N676QSRegistered aircraftBuilt 2019 · S/N 680A0213N677QSRegistered aircraftBuilt 2021 · S/N 680A0277N677TWTom Wood Aviation Inc · Indianapolis, INBuilt 2011 · S/N 510-0367N678MSPetroleum Air LLC · Houston, TXBuilt 2011 · S/N 510-0364N679QSRegistered aircraftBuilt 2020 · S/N 680A0257N67MAChartair Holdings LLC · Ponte Vedra, FLBuilt 2007 · S/N 680-0148N67PCTextron Aviation Inc · Wichita, KSS/N 680A0496N67PFPrent Corp · Janesville, WIBuilt 2017 · S/N 680A0088N67TWRegistered aircraftBuilt 2016 · S/N 680-0565N680ACRegistered aircraftBuilt 2026 · S/N 680A0472N680AGCronus680 LLC · Cleveland, OHBuilt 2007 · S/N 680-0166N680AKMid Oaks Investments LLC · Buffalo Grove, ILBuilt 2009 · S/N 680-0283N680ATKemair LLC · Shelbyville, KYBuilt 2008 · S/N 680-0192N680AVAvalair Aircraft Management LLC · Brookshire, TXBuilt 2005 · S/N 680-0049N680BFMustang Sally LLC · Wilmington, DEBuilt 2008 · S/N 680-0244N680BGTextron Aviation Inc · Wichita, KSS/N 680A0494N680BHBluecross Blueshield Of Tennessee Inc · Chattanooga, TNBuilt 2020 · S/N 680-0596N680CCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 680-0568N680CMMewbourne Oil Company · Tyler, TXBuilt 2008 · S/N 680-0194N680CSFd Air LLC · Prairie Village, KSBuilt 2007 · S/N 680-0139N680CWLookout Mountain Air LLC · Chattanooga, TNBuilt 2018 · S/N 680-0582N680DCCi Leasing LLC · Saint Cloud, MNBuilt 2007 · S/N 680-0146N680DERegent Trust Corp Trustee · Wichita, KSS/N 510-0005N680DJDirect Jet Charter LLC · Greensboro, NCBuilt 2016 · S/N 680A0030N680EAErgon Aviation LLC · Jasper, ALBuilt 2012 · S/N 680-0327N680FDFederated Hermes Inc · Pittsburgh, PABuilt 2009 · S/N 680-0289N680FSDiesel Acquisitions LLC · Milpitas, CABuilt 2008 · S/N 680-0234N680GVery Motivated LLC · Fountain Valley, CABuilt 2009 · S/N 680-0280N680GRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 680-0210N680HAHawkins Aviation LLC · Carlsbad, CABuilt 2014 · S/N 680-0504
Back to AD 2018-07-13