Skip to content

AD 2006-04-13 R1

Registered aircraft · 671

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.

N18BNWorld Rep LLC · Toa Baja, PRBuilt 2012 · S/N 5402 N18CJ18cj LLC · Norfolk, VAS/N 5245 N18GNNair LLC · Purchase, NYBuilt 2008 · S/N 5180 N18HInfinity & Beyond LLC · South Bend, INBuilt 2011 · S/N 5328 N18S5531 LLC · Seattle, WABuilt 2015 · S/N 5531 N1902PTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 4192 N192NCScp Aviation LLC · Boca Raton, FLBuilt 2008 · S/N 4126 N1932PMozart Investments Inc · Roanoke, VABuilt 2016 · S/N 5549 N1963NWater Force One LLC · Diamond Bar, CABuilt 2012 · S/N 4268 N1964MTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 5558 N196CCPhoenix Nap Management Resources LLC · Phoenix, AZBuilt 2004 · S/N 4005 N1986RRts Administrative Service Inc · Overland Park, KSBuilt 2012 · S/N 4263 N198RLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 5588 N199THTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 5113 N1CCTonkawa Inc · Minnetonka, MNBuilt 2013 · S/N 5419 N1HCHardesty-Gulfstream LLC · Tulsa, OKBuilt 2003 · S/N 5009 N1NKBase Aviation LLC · Jupiter, FLBuilt 2015 · S/N 5534 N1RPPts As LLC · Reading, PABuilt 2013 · S/N 5458 N200CKMacs Aviation LLC · Columbus, INBuilt 2014 · S/N 4304 N200KPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 5170 N203RCMingo Air LLC · Greensboro, NCBuilt 2010 · S/N 4211 N204AMercury International Holdings LLC · Salt Lake City, UTBuilt 2011 · S/N 5341 N20GGoodyear Tire & Rubber Co · Akron, OHBuilt 2010 · S/N 4212 N210AMShamrock Aviation LLC · Miami, FLBuilt 2010 · S/N 4207 N21112Ihgh LLC · Salt Lake City, UTS/N 4282 N2120Wilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 5468 N212VZNapleton Aviation Group LLC · Sugar Grove, ILBuilt 2014 · S/N 4325 N213TGBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4219 N218HFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 5587 N219TFMaple Holdings LLC · Kansas City, MOBuilt 2013 · S/N 4292 N21EHRegistered aircraftBuilt 2007 · S/N 5141 N21UGiven To Fly Holdings LLC · West Chicago, ILS/N 5379 N21UCUnited Co · Bristol, VABuilt 2014 · S/N 5484 N221FFGayas LLC · Lowell, MABuilt 2009 · S/N 5221 N221JRNorthview Aviation LLC · The Woodlands, TXBuilt 2012 · S/N 4257 N222GVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 5222 N222ZZMissaglia Aviation LLC · Rochester, NYBuilt 2008 · S/N 4137 N223AEmmanuel Group · North Wilkesboro, NCS/N 5583 N224BHBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4241 N227SVHeritage Double Eagle LLC · Queensbury, NYS/N 4210 N2291RIngersoll Rand Inc · Davidson, NCBuilt 2017 · S/N 5565 N230BDGlobal Pursuits LLC · New York, NYBuilt 2006 · S/N 5115 N231CETvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 5232 N236KRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 4209 N236LPCrest Aviation II LLC · Newport Beach, CABuilt 2010 · S/N 4206 N237GAOrange County/Sunbird Aviation LLC · Costa Mesa, CABuilt 2015 · S/N 5523 N237GRRed Flag Two Ltd · Miamisburg, OHBuilt 2006 · S/N 4055 N239MJG4sp Holdings LLC · West Palm Beach, FLBuilt 2005 · S/N 5095 N23DQJfb3 LLC · Atlanta, GABuilt 2007 · S/N 5148 N241CHTtx 2 LLC · Las Vegas, NVBuilt 2011 · S/N 4217

Back to AD 2006-04-13 R1