Skip to content

Registered aircraft · 67

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

N100GNFertitta Entertainment Holdings LLC · Houston, TXBuilt 2009 · S/N 6847 N155JECjb Equipment Leasing LLC · Naples, FLBuilt 2003 · S/N 6633 N155RBAerospace Trust Management LLC Trustee · Wilmington, DES/N 6583 N155RDCastro Be LLC · Miami, FLBuilt 2000 · S/N 6580 N155TDAjd Aviation LLC · Dorado, PRS/N 6664 N155UMRegents Of The University Of Michigan · Ann Arbor, MIBuilt 2011 · S/N 6934 N156UMRegents Of The University Of Michigan · Ann Arbor, MIBuilt 2011 · S/N 6935 N157UMRegents Of The University Of Michigan · Ann Arbor, MIBuilt 2011 · S/N 6933 N176MTDr Heli Acquistion LLC · Princeton, NJBuilt 2004 · S/N 6677 N178MTTribeca Heli LLC · Princeton, NJBuilt 1998 · S/N 6527 N17KBTrevor Corp · Grayslake, ILS/N 6526 N225HHIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 2015 · S/N 2961 N234VMIntegrity Aircraft Title Holdings LLC · Portland, ORS/N 6548 N247HHIntegrity Aircraft Title Holdings LLC · Portland, ORS/N 6529 N290TCBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 2905 N332AValiair Limited Co Trustee · Casper, WYBuilt 2000 · S/N 2540 N332HCBank Of Utah Trustee · Salt Lake City, UTBuilt 1990 · S/N 2319 N332NValiair Limited Company Trustee · Casper, WYBuilt 1994 · S/N 2408 N332RValiair Lc Trustee · Casper, WYBuilt 1991 · S/N 2347 N332XValiair Ltd Co Trustee · Casper, WYBuilt 1992 · S/N 2384 N365JABank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 6585 N365RTIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 2002 · S/N 6624 N368EVValiair Limited Company Trustee · Casper, WYBuilt 1988 · S/N 2179 N38MDBank Of Utah Trustee · Salt Lake City, UTBuilt 1989 · S/N 6335 N403HHIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 1999 · S/N 6570 N406RGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1993 · S/N 2406 N444KLIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 2008 · S/N 9010 N444YUnion Airspeed LLC · Cincinnati, OHBuilt 2008 · S/N 6827 N44DSDs Air II LLC · Carrollton, VABuilt 2003 · S/N 6615 N506ACAir Center Helicopters Inc · Burleson, TXS/N 2707 N507ACAir Center Helicopters Inc · Burleson, TXS/N 2674 N509ACTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 2809 N510ACAir Center Helicopters Inc · Burleson, TXBuilt 2009 · S/N 2732 N511ACAir Center Helicopters Inc · Burleson, TXS/N 2681 N547HFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 2547 N551ACVertical Aviation No 1 LLC · Miami, FLBuilt 2012 · S/N 2842 N552ACVertical Aviation No 1 LLC · Miami, FLBuilt 2014 · S/N 2876 N553ACVertical Aviation No 1 LLC · Miami, FLBuilt 2014 · S/N 2913 N554ACVertical Aviation No 1 LLC · Miami, FLBuilt 2011 · S/N 2818 N557ACVertical Aviation No 1 LLC · Miami, FLBuilt 2014 · S/N 2900 N561ACAir Center Helicopters Inc · Burleson, TXBuilt 2012 · S/N 2821 N563ACAir Center Helicopters Inc · Burleson, TXBuilt 2012 · S/N 2825 N568ACVertical Aviation No 1 LLC · Miami, FLBuilt 2011 · S/N 2785 N569ACVertical Aviation No 1 LLC · Miami, FLBuilt 2011 · S/N 2790 N570ACVertical Aviation No 1 LLC · Miami, FLBuilt 2009 · S/N 2724 N572ACVertical Aviation No 1 LLC · Miami, FLBuilt 2009 · S/N 2728 N576ACVertical Aviation No 1 LLC · Miami, FLBuilt 2012 · S/N 2849 N582ACTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 2777 N590ACAir Center Helicopters Inc · Burleson, TXBuilt 2008 · S/N 2680 N591ACAir Center Helicopters Inc · Burleson, TXBuilt 2008 · S/N 2685

Back to AD 2015-26-01