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.

N623TAL3 Harris Technologies Inc · Waco, TXBuilt 2012 · S/N 5374 N626RAMavir LLC · Albany, NYBuilt 2007 · S/N 5176 N635EPla Aircraft LLC · Detroit, MIBuilt 2016 · S/N 4355 N640WBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5416 N645CCL3harris Technologies Flight Capital LLC · Greenville, TXS/N 5496 N645DCDfj LLC · Denver, COBuilt 2016 · S/N 4351 N645EARegistered aircraftN-number assigned (import), not yet registeredS/N 5590 N645LHL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2020 · S/N 5606 N650LGWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 4174 N65CCNbi Holdings LLC · New Bremen, OHBuilt 2008 · S/N 5207 N65KLRegency Aviation LLC · Edgewater, MDBuilt 2004 · S/N 5035 N660HH94924 LLC · Medford, ORBuilt 2009 · S/N 5255 N663CBCb Aviation Inc · Ogden, UTBuilt 2006 · S/N 4058 N665JJUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 5126 N668EMBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 4299 N669TN600ty LLC · Plainview, TXBuilt 2010 · S/N 4186 N66CCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 5375 N670RRTvpx Trust Co LLC · North Salt Lake, UTBuilt 2010 · S/N 5281 N671LEGreen Sky Aviation LLC · Jupiter, FLBuilt 2006 · S/N 5130 N674BPTvpx Trust Co LLC Trustee · North Salt Lake, UTS/N 4093 N67JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 4092 N6857FCudlob 4087 LLC · South Miami, FLBuilt 2007 · S/N 4087 N688CBFrc Holding Inc V · Dover, DEBuilt 2007 · S/N 5172 N699KRBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 5171 N69CKCd 321 LLC · Austin, TXBuilt 2004 · S/N 5046 N6JGJg Leasing LLC · Bradenton, FLBuilt 2011 · S/N 4218 N6JPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 5062 N700MVMira Vista Aviation Inc · Irvine, CABuilt 2005 · S/N 4026 N701WCKalihiwai Aviation LLC · Aspen, COBuilt 2011 · S/N 4224 N703BGTen Point Tours Inc · Nashville, TNBuilt 2009 · S/N 4169 N703FSFlo-Sun Aircraft Inc · West Palm Beach, FLBuilt 2010 · S/N 5307 N708JHUnited States Government · Washington, DCFirst renewal noticeBuilt 2019 · S/N 5599 N71111Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 5316 N711EGG550 N711 LLC · Newport Beach, CABuilt 2009 · S/N 5231 N712LWWanderweg Holdings LLC · Salt Lake City, UTBuilt 2007 · S/N 5154 N716GCGreat Clips Inc · Minneapolis, MNBuilt 2014 · S/N 5499 N716WRTrans Texas Jet Transport Inc · Realitos, TXBuilt 2005 · S/N 4034 N717LSN717ls LLC · Miami Beach, FLBuilt 2008 · S/N 4109 N718PMConfectionery Advantage LLC · Park Ridge, NJBuilt 2012 · S/N 5384 N721KJBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 5299 N721RHRh · Wilmington, DEBuilt 2003 · S/N 5010 N727SJDataone Systems LLC · Dallas, TXBuilt 2012 · S/N 5388 N727TEMillrock Aviation Financial LLC · Danbury, CTBuilt 2008 · S/N 5223 N728ECChouest Air Inc · Cut Off, LABuilt 2013 · S/N 5439 N728MHM/I Homes Of Delaware LLC · Columbus, OHBuilt 2015 · S/N 4346 N73RPTransportation Holdings IV LLC · Dallas, TXBuilt 2015 · S/N 5528 N74VZRegistered aircraftBuilt 2020 · S/N 5619 N750LGWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 5096 N751LGWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 5244 N75CCNbi LLC · New Bremen, OHBuilt 2005 · S/N 5065

Back to AD 2006-04-13 R1