Registered aircraft · 87

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:2005-19-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:2005-19-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:2005-19-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:2005-19-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:2005-19-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:2005-19-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.

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 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 N657RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000115 N702SYSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 17000029 N703SYSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 17000010 N705SYSkywest Airlines Inc · St George, UTBuilt 2008 · S/N 17000065 N706SYSkywest Airlines Inc · St George, UTS/N 17000035 N709SYSkywest Airlines Inc · Saint George, UTS/N 17000074 N731SYSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 17000009 N732SYSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 17000011 N739AEWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000080 N740MRWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000082 N741AKWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 17000138 N742GRWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 17000140 N743MBWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 17000143 N744DBWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 17000130 N745JBWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000071 N746CCWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 17000042 N748RRWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000072 N749BMWilmington Trust Company Trustee · Wilmington, DEBuilt 2006 · S/N 17000133 N750BDWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000075 N751ABWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000078 N760MQWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 17000294 N761RWWilmington Trust Co Trustee · Wilmington, DES/N 17000296 N762DTWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 17000298 N763CCWilmington Trust Company Trustee · Wilmington, DES/N 17000300 N764JDWilmington Trust Company Trustee · Wilmington, DEBuilt 2009 · S/N 17000302 N765STAmerican Airlines Inc · Fort Worth, TXBuilt 2006 · S/N 17000128 N766JMWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 17000305 N768RDAmerican Airlines Inc · Fort Worth, TXBuilt 2008 · S/N 17000230 N769KWAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 17000024 N770JMAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 17000025 N771JVAmerican Airlines Inc · Fort Worth, TXBuilt 2005 · S/N 17000087 N772MRAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 17000092 N774JGWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 17000007 N776MSWilmington Trust Company Trustee · Wilmington, DEBuilt 2004 · S/N 17000050

Back to AD 2005-19-01