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.

N533GVWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 5330 N537NASetna Express LLC · Lincolnshire, ILBuilt 2008 · S/N 5188 N539JSG550 Msn 5390 Leasing LLC · Bay Harbor Islands, FLBuilt 2012 · S/N 5390 N542GDUnited States Air Force 645 Aesg · Wright Pat, OHBuilt 2016 · S/N 5542 N5465MBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 5465 N550Kendall Road Pegasus LLC · Chicago, ILBuilt 2018 · S/N 5562 N55011Swr Services II LLC · Los Altos, CABuilt 2014 · S/N 5476 N550AA711 Cody Inc · Teterboro, NJBuilt 2003 · S/N 5020 N550AGJet Lag 76 LLC · Dover, DEBuilt 2011 · S/N 5338 N550ALRegistered aircraftBuilt 2013 · S/N 5443 N550AVPriority Air 2 LLC · Little Rock, ARBuilt 2014 · S/N 5490 N550CKCalvin Klein Studio LLC · Santa Monica, CABuilt 2009 · S/N 5251 N550DADraper Management Co LLC · San Mateo, CABuilt 2017 · S/N 5556 N550DRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 5413 N550DXLugus Aviation LLC · Windermere, FLBuilt 2015 · S/N 5517 N550EWW & W Jets LLC · Wichita, KSBuilt 2006 · S/N 5102 N550FRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 5415 N550GAGulfstream Leasing LLC · Savannah, GABuilt 2012 · S/N 5363 N550GFG55010 LLC · Miami Beach, FLBuilt 2010 · S/N 5284 N550GHRegistered aircraftBuilt 2014 · S/N 5477 N550GPN550gp LLC · Ontario, CABuilt 2007 · S/N 5173 N550GW711 Cody Inc · Teterboro, NJBuilt 2003 · S/N 5006 N550HQHuck Aviation LLC · Kalispell, MTS/N 5071 N550KFWilmington Trust Company Trustee · Wilmington, DEBuilt 2015 · S/N 5504 N550KJCasco Bay LLC · Wilmington, DEBuilt 2008 · S/N 5203 N550KRN550kr LLC · Salt Lake City, UTBuilt 2014 · S/N 5491 N550LKN550lk LLC · Palo Alto, CABuilt 2003 · S/N 5023 N550MVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 5360 N550NMH4a LLC · Austin, TXBuilt 2006 · S/N 5122 N550PLTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 5218 N550RPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 5184 N550SNSn234 LLC · New York, NYBuilt 2008 · S/N 5195 N550TBHilltop Asset Holdings LLC · Saratoga Springs, NYBuilt 2006 · S/N 5107 N550TSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 5147 N550UNAirx G550 LLC · Newark, DES/N 5029 N550VETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 5365 N550VRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 5049 N550WWTk-421 LLC · Las Vegas, NVBuilt 2008 · S/N 5214 N551AVTfb Aviation LLC · Wilmington, DEBuilt 2017 · S/N 5569 N551FRBlackbird Jet LLC · Boca Raton, FLBuilt 2004 · S/N 5040 N551HADepartment Of Defense Missile Defense Agency · Tulsa, OKBuilt 2011 · S/N 5345 N551SNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 5620 N5524Avpro Inc · Annapolis, MDS/N 5524 N552HADepartment Of Defense Missile Defense Agency · Tulsa, OKBuilt 2010 · S/N 5288 N552MWSchweitzer Aircraft Leasing Inc · Pullman, WABuilt 2020 · S/N 5615 N552SNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 5625 N553GTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 5053 N553HADepartment Of Defense Missile Defense Agency · Tulsa, OKBuilt 2010 · S/N 5290 N553SNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 5575 N554DGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 5196

Back to AD 2006-04-13 R1