Registered aircraft · 293

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

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-06-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:2017-06-13') ORDER BY n_number

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-06-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:2017-06-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.

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-06-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:2017-06-13')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N545SStark Aircraft LLC · North Canton, OHS/N 680-0545 N557SLSlc Division 4 LLC · Nashville, TNBuilt 2008 · S/N 6800199 N569CGCardinal Ig Co · Eden Prairie, MNBuilt 2017 · S/N 680-0569 N570PKPrimoris Services Corp · Dallas, TXBuilt 2016 · S/N 680-0557 N58EPSel Services LLC · Houston, TXBuilt 2017 · S/N 680-0571 N595ABFreedom Isnt Free LLC · Laguna Beach, CABuilt 2006 · S/N 680-0090 N59TFKlp Air LLC · Cincinnati, OHBuilt 2011 · S/N 680-0311 N612JDOtd Aviation LLC · Bethesda, MDBuilt 2019 · S/N 680-0585 N624SVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 680-0124 N631CBKmac Aircraft Company LLC · Lafayette, LAS/N 680-0227 N637SVTextron Financial Corp · Wichita, KSBuilt 2005 · S/N 680-0037 N63TMLivre Air LLC · Cincinnati, OHBuilt 2005 · S/N 680-0019 N6464Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 680-0158 N660HCDec LLC · Atlanta, GABuilt 2015 · S/N 680-0553 N669BBJdhim-Xls LLC · Dallas, TXBuilt 2008 · S/N 680-0212 N671MDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 680-0524 N67MAChartair Holdings LLC · Ponte Vedra, FLBuilt 2007 · S/N 680-0148 N67TWRegistered aircraftBuilt 2016 · S/N 680-0565 N680AGCronus680 LLC · Cleveland, OHBuilt 2007 · S/N 680-0166 N680AKMid Oaks Investments LLC · Buffalo Grove, ILBuilt 2009 · S/N 680-0283 N680ATKemair LLC · Shelbyville, KYBuilt 2008 · S/N 680-0192 N680AVAvalair Aircraft Management LLC · Brookshire, TXBuilt 2005 · S/N 680-0049 N680BFMustang Sally LLC · Wilmington, DEBuilt 2008 · S/N 680-0244 N680BHBluecross Blueshield Of Tennessee Inc · Chattanooga, TNBuilt 2020 · S/N 680-0596 N680CCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 680-0568 N680CMMewbourne Oil Company · Tyler, TXBuilt 2008 · S/N 680-0194 N680CSFd Air LLC · Prairie Village, KSBuilt 2007 · S/N 680-0139 N680CWLookout Mountain Air LLC · Chattanooga, TNBuilt 2018 · S/N 680-0582 N680DCCi Leasing LLC · Saint Cloud, MNBuilt 2007 · S/N 680-0146 N680EAErgon Aviation LLC · Jasper, ALBuilt 2012 · S/N 680-0327 N680FDFederated Hermes Inc · Pittsburgh, PABuilt 2009 · S/N 680-0289 N680FSDiesel Acquisitions LLC · Milpitas, CABuilt 2008 · S/N 680-0234 N680GVery Motivated LLC · Fountain Valley, CABuilt 2009 · S/N 680-0280 N680GRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 680-0210 N680HAHawkins Aviation LLC · Carlsbad, CABuilt 2014 · S/N 680-0504 N680JL680 Partners LLC · Houston, TXBuilt 2005 · S/N 680-0054 N680KAKongaire LLC · High Point, NCBuilt 2020 · S/N 680-0593 N680KJDaf Transportation LLC · Boise, IDBuilt 2014 · S/N 680-0521 N680KRJsr Real Estate Investment Group LLC · Danville, CABuilt 2006 · S/N 680-0087 N680KSBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 680-0186 N680LGLarson Express LLC · Stafford, MOBuilt 2013 · S/N 680-0509 N680MBGeneral Leasing Of Michigan LLC · Lapeer, MIBuilt 2006 · S/N 680-0093 N680MCMurphy Co · Eugene, ORBuilt 2013 · S/N 680-0515 N680MKMike Kilo Aviation LLC · Byron Center, MIBuilt 2013 · S/N 680-0348 N680MLRio Grande Helicopters Inc · Dover, DEBuilt 2014 · S/N 680-0525 N680NSNo Slac LLC · Duncan, OKBuilt 2008 · S/N 680-0209 N680NXMa Monarch LLC · Phoenix, AZBuilt 2006 · S/N 680-0071 N680PBProsperity Bank · El Campo, TXBuilt 2007 · S/N 680-0145 N680PCWings & Wheels LLC · Oakland, CABuilt 2004 · S/N 680-0006 N680PGWd Larson Companies Ltd Inc · Minneapolis, MNBuilt 2006 · S/N 680-0108

Back to AD 2017-06-13