AD 2007-13-13

Registered aircraft · 688

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

N653QXHorizon Air Industries Inc · Seatac, WABuilt 2022 · S/N 17000930N653RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000076N654QXHorizon Air Industries Inc · Seattle, WABuilt 2022 · S/N 17000933N654RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000104N655QXHorizon Air Industries Inc · Seattle, WABuilt 2023 · S/N 17000940N655RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000105N656QXHorizon Air Industries Inc · Seattle, WABuilt 2023 · S/N 17000942N656RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000113N657QXHorizon Air Industries Inc · Seatac, WABuilt 2023 · S/N 17000943N657RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000115N658QXHorizon Air Industries Inc · Seattle, WABuilt 2023 · S/N 17000945N659QXHorizon Air Industries Inc · Seatac, WABuilt 2023 · S/N 17000947N660QXHorizon Air Industries Inc · Seatac, WABuilt 2023 · S/N 17000948N661QXHorizon Air Industries Inc · Seattle, WABuilt 2023 · S/N 17000955N662QXHorizon Air Industries Inc · Seattle, WABuilt 2023 · S/N 17000956N663QXHorizon Air Industries Inc · Seattle, WABuilt 2024 · S/N 17000961N664QXHorizon Air Industries Inc · Seattle, WABuilt 2024 · S/N 17000963N665QXHorizon Air Industries Inc · Seattle, WABuilt 2024 · S/N 17000965N667QXHorizon Air Industries Inc · Seatac, WABuilt 2025 · S/N 17000989N668QXHorizon Air Industries Inc · Seatac, WAS/N 17000992N669QXHorizon Air Industries Inc · Seattle, WAS/N 17000995N670QXHorizon Air Industries Inc · Seatac, WAS/N 17001032N671QXHorizon Air Industries Inc · Seatac, WAS/N 17001034N672QXHorizon Air Industries Inc · Seatac, WAS/N 17001039N702SYSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 17000029N703SYSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 17000010N705SYSkywest Airlines Inc · St George, UTBuilt 2008 · S/N 17000065N706SYSkywest Airlines Inc · St George, UTS/N 17000035N709SYSkywest Airlines Inc · Saint George, UTS/N 17000074N721YXRepublic Airways Inc · Carmel, INBuilt 2015 · S/N 17000493N722YXRepublic Airways Inc · Carmel, INBuilt 2015 · S/N 17000496N723YXRepublic Airways Inc · Carmel, INBuilt 2015 · S/N 17000498N724YXRepublic Airways Inc · Carmel, INBuilt 2015 · S/N 17000502N725YXRepublic Airways Inc · Carmel, INBuilt 2015 · S/N 17000506N726YXRepublic Airways Inc · Carmel, INBuilt 2015 · S/N 17000507N727YXRepublic Airways Inc · Carmel, INBuilt 2015 · S/N 17000509N728YXRepublic Airways Inc · Carmel, INBuilt 2015 · S/N 17000510N729YXRepublic Airways Inc · Carmel, INBuilt 2015 · S/N 17000512N730YXRepublic Airways Inc · Carmel, INBuilt 2015 · S/N 17000518N731SYSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 17000009N731YXRepublic Airways Inc · Carmel, INBuilt 2015 · S/N 17000520N732SYSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 17000011N732YXRepublic Airways Inc · Carmel, INBuilt 2015 · S/N 17000521N733YXRepublic Airways Inc · Carmel, INBuilt 2016 · S/N 17000539N736YXRepublic Airways Inc · Carmel, INBuilt 2016 · S/N 17000541N739AEWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000080N739YXRepublic Airways Inc · Carmel, INBuilt 2016 · S/N 17000542N740MRWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000082N740YXRepublic Airways Inc · Carmel, INBuilt 2016 · S/N 17000544N741AKWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 17000138
Back to AD 2007-13-13