Skip to content

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.

N680QAProbst Electric Inc · Heber City, UTBuilt 2014 · S/N 680-0528 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 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 N681HSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 680-0287 N681QATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 680-0308 N681SBN681sb LLC · Indianapolis, INBuilt 2007 · S/N 680-0172 N682HSBa Air LLC · Baltimore, MDBuilt 2010 · S/N 680-0291 N685VMTtx Holdings LLC · Las Vegas, NVBuilt 2015 · S/N 680-0550 N686CPCp Air LLC · New York, NYBuilt 2015 · S/N 680-0543 N688MPE2 Bravo Holdco LLC · Arvada, COBuilt 2007 · S/N 680-0142 N688VMPanorama Jets LLC · Dover, DEBuilt 2014 · S/N 680-0510 N689WTByler 689 LLC · Brookshire, TXBuilt 2008 · S/N 680-0221 N68EUBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 680-0208 N68HQBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 680-0518 N68SLValor Aviation LLC · Rhome, TXBuilt 2009 · S/N 680-0264 N690LADavis Air LLC · Elizabethtown, KYBuilt 2012 · S/N 680-0324 N692AZBlanco Air Services LLC · Houston, TXBuilt 2005 · S/N 680-0031 N6GULkm Inc · Santa Monica, CABuilt 2009 · S/N 680-0268 N708BG503kh Holdings LLC · Wilmington, DEBuilt 2012 · S/N 680-0325 N70RFPro Jet Leasing LLC · Cincinnati, OHBuilt 2012 · S/N 680-0329 N711FSFs Leasing LLC · Newark, DEBuilt 2015 · S/N 680-0548 N719NCC & C Aviation LLC · Lynchburg, VABuilt 2014 · S/N 680-0536 N71LUC&C Aviation LLC · Lynchburg, VABuilt 2008 · S/N 680-0256 N7202Tlg Aviation II LLC · Saint Louis, MOBuilt 2012 · S/N 680-0501 N720DKEcoair LLC · Earth City, MOBuilt 2008 · S/N 680-0216 N724RMInterbank · Dover, DEBuilt 2011 · S/N 680-0314 N73UCDesert Sky LLC · Evansville, INBuilt 2006 · S/N 680-0086 N7402Cerium Technology Ventures LLC · Dallas, TXBuilt 2006 · S/N 680-0082 N7403Kent Investors V LLC · Grand Rapids, MIBuilt 2008 · S/N 680-0222 N740PTPoet Inc · Sioux Falls, SDBuilt 2015 · S/N 680-0544 N751BGGreen Mountain Boys LLC · Orangeburg, SCBuilt 2007 · S/N 680-0181 N757LLSovereign Asset Co LLC · Lubbock, TXBuilt 2019 · S/N 680-0590 N758SP680 Private LLC · Hillside, ILBuilt 2005 · S/N 680-0015 N770MWMarvin Lumber & Cedar Company LLC · Warroad, MNBuilt 2021 · S/N 680-0600 N770RMJennifer Air LLC · Mooresville, NCBuilt 2007 · S/N 680-0159 N777BKNevada Restaurant Services Inc · North Las Vegas, NVBuilt 2008 · S/N 680-0247 N777CUJemk Services LLC · Mckinney, TXBuilt 2006 · S/N 680-0096 N777UTSho Deen Inc · Geneva, ILBuilt 2005 · S/N 680-0048 N789MJEagle Union Quest One LLC · Philadelphia, PAFirst renewal noticeBuilt 2008 · S/N 680-0205 N798LGJ&J Express Services LLC · Avenel, NJBuilt 2016 · S/N 680-0563

Back to AD 2017-06-13