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

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

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.

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

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.

N680JAState Of Texas · Austin, TXBuilt 2026 · S/N 680A0473 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 N680LFCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2022 · S/N 680A-0313 N680LGLarson Express LLC · Stafford, MOBuilt 2013 · S/N 680-0509 N680LLFitr II LLC · Plano, TXBuilt 2021 · S/N 680A0249 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 N680NYTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 680A0317 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 N680QAProbst Electric Inc · Heber City, UTBuilt 2014 · S/N 680-0528 N680QSRegistered aircraftBuilt 2021 · S/N 680A0278 N680RAN680ra LLC · Dover, DES/N 680-0530 N680RBRmc Leasing LLC · Kittanning, PABuilt 2013 · S/N 680-0349 N680RKMidwest Jet Charter Inc · Mattoon, ILBuilt 2015 · S/N 680-0547 N680SABjr Management LLC · Goldsboro, NCBuilt 2008 · S/N 680-0237 N680SPSchwarz Partners Lp · Carmel, INBuilt 2016 · S/N 680-0564 N680SWBank Of Utah Trustee · Salt Lake City, UTBuilt 2025 · S/N 680A0440 N680TRQuanta Aviation Equipment Company LLC · Wilmington, DEBuilt 2016 · S/N 680-0560 N680TSTransatlantic Air Leasing LLC · Miami, FLBuilt 2004 · S/N 680-0013 N680UTGulfshore Breeze LLC · Newark, DEBuilt 2007 · S/N 680-0153 N680VMTtx Holdings LLC · Las Vegas, NVBuilt 2015 · S/N 680-0541 N680WCPeregrine Aviation Company LLC · Roy, MTBuilt 2019 · S/N 680-0584 N680WPB Squared Aviation LLC · Kalamazoo, MIBuilt 2008 · S/N 680-0236 N680XPAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2009 · S/N 680-0282 N681ANCrescent Solutions Group LLC · Park City, UTBuilt 2010 · S/N 510-0348 N681CLTextron Aviation Inc · Wichita, KSBuilt 2014 · S/N 680A0001 N681HSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 680-0287 N681KCorporate Jet Leasing Co LLC · Wichita, KSBuilt 2019 · S/N 680A0208 N681QATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 680-0308 N681QSRegistered aircraftBuilt 2019 · S/N 680A0214 N681SBN681sb LLC · Indianapolis, INBuilt 2007 · S/N 680-0172 N682HSBa Air LLC · Baltimore, MDBuilt 2010 · S/N 680-0291 N682KCorporate Jet Leasing Co LLC · Wichita, KSBuilt 2019 · S/N 680A0209 N683ACEpc Tranportation LLC · Billings, MTBuilt 2016 · S/N 680A0024 N683KCorporate Jet Leasing Co LLC · Atlanta, GABuilt 2019 · S/N 680A0224 N684BBEdward Via Virginia College Of Osteopathic Of Med · Blacksburg, VABuilt 2015 · S/N 680A0016 N684DBBerge Air LLC · Albuquerque, NMBuilt 2021 · S/N 680A0253 N684QSLhm Investments LLC · Oklahoma City, OKBuilt 2019 · S/N 680A0215 N684THRjk Air LLC · Syracuse, NYBuilt 2008 · S/N 510-0067 N685KCRegistered aircraftBuilt 2026 · S/N 680A0471

Back to AD 2018-07-13