Skip to content

Registered aircraft · 431

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

N538MMenards Inc · Eau Claire, WIBuilt 2001 · S/N 145467 N540MMenard Inc · Eau Claire, WIBuilt 2006 · S/N 14500977 N548MGa-Erj135 LLC · Seiling, OKBuilt 2000 · S/N 145364 N600BPAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145044 N600WBBd Advisors LLC · Beaumont, TXBuilt 2008 · S/N 14501032 N602AEAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145048 N603KCAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145055 N604AEAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145058 N605KSAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145059 N605WGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 14500980 N606AEAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145062 N607AEAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145064 N608JYD Aircraft Leasing Company LLC · Wilmington, DES/N 145231 N608LMAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145068 N609DPAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145069 N610AEAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145073 N611AEAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145074 N611BVD&B Truck & Trailer Services LLC · Nashville, TNBuilt 2002 · S/N 145-637 N612AEAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145079 N613AEAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145081 N614AEAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145086 N615AEAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145087 N616AEAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145092 N617AEAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145093 N618AEAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145097 N619AEAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145101 N620AEAmerican Airlines Inc · Fort Worth, TXS/N 145102 N621AEAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145105 N622AEAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 145108 N623AEAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 145109 N624AEAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 145111 N625AEAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 145115 N626AEAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 145117 N627AEAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 145121 N629AEAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 145130 N631AEAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 145139 N632AEAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 145143 N633AEAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 145148 N634AEAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 145150 N635AEAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 145158 N636AEAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 145160 N637AEAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 145170 N638AEAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 145172 N639AEAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 145182 N640AEAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 145183 N641AEAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 145191 N642AEAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 145193 N642TKAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2002 · S/N 145642 N643AEAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 145200 N644AEAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 145204

Back to AD 2004-25-21