Skip to content

Registered aircraft · 126

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-11-15') 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-11-15') 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-11-15')
    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-11-15')
  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-11-15')
  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-11-15')
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.

N108MPAircraft Propeller Service LLC · Lake Zurich, ILS/N 19000108 N111NHE190 Msn111 LLC · Dover, DEBuilt 2007 · S/N 19000111 N112BZBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 19000077 N114BZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 19000092 N115BZWilmington Trust Co Trustee · Wilmington, DES/N 19000096 N116BZWilmington Trust Co Trustee · Wilmington, DES/N 19000101 N120BZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 19000115 N126BZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 19000124 N128BZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 19000132 N133ABBank Of Utah Trustee · Salt Lake City, UTS/N 19000469 N170EHHoneywell Aerospace US LLC · Phoenix, AZBuilt 2004 · S/N 17000059 N175RSAng USA III LLC · Naples, FLBuilt 2006 · S/N 17000141 N176RSAng USA I LLC · Naples, FLBuilt 2005 · S/N 17000107 N177RSAng USA II LLC · Naples, FLBuilt 2006 · S/N 17000112 N179RSAng USA IV LLC · Naples, FLS/N 17000146 N184JBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 19000008 N190JBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 19000011 N190MBBank Of Utah Trustee · Salt Lake City, UTS/N 19000524 N192JBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 19000014 N193JBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 19000017 N195ARBank Of Utah Trustee · Salt Lake City, UTS/N 19000154 N266JBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 19000054 N267JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 19000065 N273JBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 19000073 N279JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 19000090 N281JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 19000103 N283JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 19000125 N284JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 19000144 N306JBWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 19000272 N309JBWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 19000289 N317JBWilmington Trust Company Trustee · Wilmington, DEBuilt 2010 · S/N 19000363 N318JBWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 19000364 N328JBWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 19000422 N329JBWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 19000433 N337JBAdvanced Air LLC · Statesville, NCBuilt 2011 · S/N 19000473 N339JBAdvanced Air LLC · Statesville, NCBuilt 2011 · S/N 19000490 N397NCWilmington Trust Company Trustee · Wilmington, DEBuilt 2008 · S/N 19000151 N529HGBank Of Utah Trustee · Salt Lake City, UTS/N 19000529 N556ELBank Of Utah Trustee · Salt Lake City, UTS/N 19000556 N638RWRepublic Airways Inc · Carmel, INBuilt 2004 · S/N 17000053 N639RWRepublic Airways Inc · Carmel, INBuilt 2004 · S/N 17000057 N640RWRepublic Airways Inc · Carmel, INBuilt 2004 · S/N 17000058 N641RWRepublic Airways Inc · Carmel, INBuilt 2004 · S/N 17000062 N642RWRepublic Airways Inc · Carmel, INBuilt 2004 · S/N 17000063 N647RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000067 N648RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000068 N653RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000076 N654RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000104 N655RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000105 N656RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000113

Back to AD 2006-11-15