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.

N685VMTtx Holdings LLC · Las Vegas, NVBuilt 2015 · S/N 680-0550N686CPCp Air LLC · New York, NYBuilt 2015 · S/N 680-0543N687QSRegistered aircraftBuilt 2019 · S/N 680A0216N688CGCg Asset Holdings LLC · South Plainfield, NJBuilt 2025 · S/N 680A0427N688MPE2 Bravo Holdco LLC · Arvada, COBuilt 2007 · S/N 680-0142N688QSRegistered aircraftBuilt 2019 · S/N 680A0222N688VMPanorama Jets LLC · Dover, DEBuilt 2014 · S/N 680-0510N689CMOdyssey Aviation LLC · Marathon, WIBuilt 2017 · S/N 680A0089N689WTByler 689 LLC · Brookshire, TXBuilt 2008 · S/N 680-0221N68EUBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 680-0208N68GWGrady-White Boats Inc · Greenville, NCBuilt 2026 · S/N 680A0481N68HATarbert Aviation LLC · Indianapolis, INBuilt 2018 · S/N 680A0127N68HQBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 680-0518N68SLValor Aviation LLC · Rhome, TXBuilt 2009 · S/N 680-0264N68TEN68te LLC · Houston, TXBuilt 2025 · S/N 680A0417N6900BOrtiz Bros Aviation LLC · Zephyr Cove, NVBuilt 2013 · S/N 510-0444N690LADavis Air LLC · Elizabethtown, KYBuilt 2012 · S/N 680-0324N690QSRegistered aircraftBuilt 2019 · S/N 680A0223N691QSRegistered aircraftBuilt 2021 · S/N 680A0279N692AZBlanco Air Services LLC · Houston, TXBuilt 2005 · S/N 680-0031N692QSRegistered aircraftBuilt 2019 · S/N 680A0225N694QSRegistered aircraftBuilt 2019 · S/N 680A0226N695QSRegistered aircraftBuilt 2021 · S/N 680A0280N696QSRegistered aircraftBuilt 2019 · S/N 680A0227N697QSRegistered aircraftBuilt 2019 · S/N 680A0229N699QSRegistered aircraftBuilt 2019 · S/N 680A0230N69AYGs Brothers Inc · Groveland, CABuilt 2008 · S/N 510-0115N6GULkm Inc · Santa Monica, CABuilt 2009 · S/N 680-0268N700CMBaron Partners Inc · Springfield, ILBuilt 2007 · S/N 510-0009N700YYJaggers LLC · Calabasas, CABuilt 2008 · S/N 510-0148N704FCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 680A0245N704TPDream Jet LLC · Overland Park, KSBuilt 2013 · S/N 510-0437N708BG503kh Holdings LLC · Wilmington, DEBuilt 2012 · S/N 680-0325N709SPScannell Citation LLC · Indianapolis, INBuilt 2018 · S/N 680A0171N70RFPro Jet Leasing LLC · Cincinnati, OHBuilt 2012 · S/N 680-0329N710CRWestwinds LLC · Chattanooga, TNBuilt 2017 · S/N 680A0086N711AGWhitis Bradley · Killeen, TXBuilt 2024 · S/N 680A0395N711FSFs Leasing LLC · Newark, DEBuilt 2015 · S/N 680-0548N7131VConnell Blue LLC · Berkeley Heights, NJBuilt 2024 · S/N 680A0393N714RMRaj Consulting LLC · Tustin, CABuilt 2021 · S/N 680A0265N715NNicholas Services LLC · Oxford, MSBuilt 2015 · S/N 680A0012N717ETFairway Aviation LLC · Charlotte, NCBuilt 2013 · S/N 510-0443N719NCC & C Aviation LLC · Lynchburg, VABuilt 2014 · S/N 680-0536N71GShikari Equipment LLC · Beaverton, ORBuilt 2007 · S/N 510-0042N71LUC&C Aviation LLC · Lynchburg, VABuilt 2008 · S/N 680-0256N71TMMallto Enterprises LLC · Lewes, DEBuilt 2010 · S/N 510-0350N71XSWabash II Aviation LLC · Fort Lauderdale, FLBuilt 2018 · S/N 680A0174N7202Tlg Aviation II LLC · Saint Louis, MOBuilt 2012 · S/N 680-0501N720DKEcoair LLC · Earth City, MOBuilt 2008 · S/N 680-0216N724DLDrew Dennis M · Danville, CAS/N 510-0078
Back to AD 2018-07-13