Skip to content

AD 2006-04-13 R1

Registered aircraft · 672

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:2006-04-13-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-04-13-R1') 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:2006-04-13-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-04-13-R1')
  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:2006-04-13-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-04-13-R1')
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.

N554SNTvpx Trust Co LLC Trustee · North Salt Lake, UTS/N 5604 N555KHRegian Services LLC · Encino, CABuilt 2009 · S/N 5237 N5569Landmark Graphics Corp · Houston, TXBuilt 2007 · S/N 5169 N5585Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 5085 N558APLmc Leasing LLC · Tallahassee, FLBuilt 2009 · S/N 4159 N559DWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 5110 N559GGlen Alba Investments Inc Trustee · Wilmington, DEBuilt 2003 · S/N 5012 N55QCQuikrete Aircraft Leasing LLC · Atlanta, GABuilt 2014 · S/N 5495 N561SKJet Air Management LLC · Miami Beach, FLBuilt 2015 · S/N 5529 N565JMNational Oceanic And Atomospheric Administration · Lakeland, FLBuilt 2016 · S/N 5538 N568GAGulfstream Aerospace Corp · Savannah, GABuilt 2019 · S/N 5608 N568JLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 5340 N56BUBsi Holdings LLC · Portland, ORBuilt 2004 · S/N 5059 N56CAusome Aviation LLC · Newark, DEBuilt 2012 · S/N 5396 N581DWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 5353 N582DWeidner Property Management LLC · Kirkland, WABuilt 2012 · S/N 5397 N584AAramco Associated Co · Houston, TXBuilt 2015 · S/N 4341 N585DWColleen Corp · New Castle, DEBuilt 2014 · S/N 5485 N586GDGulfstream Aerospace Corp · Savannah, GABuilt 2014 · S/N 5486 N587DVFs Leasing LLC · Newark, DEBuilt 2015 · S/N 4345 N587GDGulfstream Aerospace Corp · Savannah, GABuilt 2015 · S/N 5520 N588DZGrowth Holdings LLC · Broken Arrow, OKBuilt 2010 · S/N 5272 N588GGulfstream Aerospace Corporation · Savannah, GABuilt 2014 · S/N 5488 N588PXBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 5467 N588TNTannjets Aerospace II LLC · Fort Lauderdale, FLBuilt 2006 · S/N 5109 N58AJSe Sfj LLC · Great Neck, NYBuilt 2010 · S/N 4188 N592FCJuno Aviation LLC · Juno Beach, FLBuilt 2008 · S/N 4144 N595EXTiny Bronco LLC · Newark, DEBuilt 2007 · S/N 5179 N599HRegistered aircraftBuilt 2003 · S/N 5016 N59APComputer Sciences Corp · Tysons, VABuilt 2008 · S/N 4127 N59CFTailwind Holdings LLC · San Ramon, CABuilt 2007 · S/N 4097 N5BLBlm Aviation LLC · Dover, DEBuilt 2009 · S/N 5227 N5PDMid-Atlantic Aviation III LLC · Saint Petersburg, FLBuilt 2012 · S/N 5410 N5SNDodson International Parts Inc · Rantoul, KSBuilt 2006 · S/N 5134 N603BGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 5249 N603JRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 5535 N607DDominion Energy Services Inc · Richmond, VABuilt 2017 · S/N 4365 N608CLCassandra Lee Flight Operations LLC · Las Vegas, NVBuilt 2009 · S/N 5262 N609EZYates Aviation LLC · Texarkana, TXS/N 4165 N609STWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 4153 N611JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 4256 N611JMJfm Inc · Oak Brook, ILBuilt 2003 · S/N 5001 N612AFAmeriprise Financial Inc · Oxford, CTBuilt 2006 · S/N 4069 N612MJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 5159 N613AQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 5181 N615TT17 South Briar Hollow Lane LLC · Brookshire, TXBuilt 2016 · S/N 4348 N616AFAmeriprise Financial Inc · Oxford, CTBuilt 2010 · S/N 5295 N616CAPioneer Hi-Bred International Inc · Wilmington, DEBuilt 2019 · S/N 5601 N616RKBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 5361 N620JHBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 5595

Back to AD 2006-04-13 R1