Skip to content

Registered aircraft · 333

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

N530CNCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2001 · S/N 145425 N531CNCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2001 · S/N 145469 N532CNCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2001 · S/N 145519 N534CNCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2001 · S/N 145531 N535CNCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2001 · S/N 145489 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

Back to AD 2012-19-06