Skip to content

Registered aircraft · 383

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:2015-02-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:2015-02-13') 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:2015-02-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:2015-02-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.

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:2015-02-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:2015-02-13')
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.

N27200United Airlines Inc · Chicago, ILBuilt 2006 · S/N 14500956 N27512Corporate Flight Management Inc · Smyrna, TNBuilt 2000 · S/N 145274 N284CPConocophillips Co · Houston, TXBuilt 2013 · S/N 14501178 N290MADodson Parts International Inc · Rantoul, KSS/N 145434 N291BCIbc Airways Inc · Fort Lauderdale, FLBuilt 2004 · S/N 145782 N29917Delux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145414 N304CEBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 145326 N31131United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145705 N33182United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500909 N34110Bank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 145658 N376MANewcastle Aviation Partners LLC · Fort Myers, FLS/N 145420 N3DEChampion Air LLC · Mooresville, NCBuilt 2002 · S/N 145626 N402ATAero Technologies Inc · Van Nuys, CABuilt 2003 · S/N 145702 N403RWRvr Air Charter LLC · Ft Worth, TXBuilt 2000 · S/N 145262 N404ATAero Aircraft Holdings LLC · Van Nuys, CABuilt 2003 · S/N 145715 N410MADodson Parts International Inc · Rantoul, KSS/N 145313 N41104United Airlines Inc · Chicago, ILBuilt 2002 · S/N 145646 N438MANewcastle Aviation Partners LLC · Fort Myers, FLS/N 145232 N43VAAdvanced Air LLC · Statesville, NCBuilt 1998 · S/N 145061 N443MANewcastle Aviation Partners LLC · Fort Meyers, FLS/N 145255 N46VAAdvanced Air LLC · Statesville, NCBuilt 1999 · S/N 145103 N47VAAdvanced Air LLC · Statesville, NCBuilt 1999 · S/N 145110 N48901Delux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145501 N49VAAdvanced Air LLC · Statesville, NCBuilt 1999 · S/N 145.151 N500DEChampion Air LLC · Mooresville, NCBuilt 1998 · S/N 145084 N508RHHms Holdings LLC · Charlotte, NCBuilt 2003 · S/N 145769 N509GUTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 145535 N509RHHms Holdings LLC · Charlotte, NCBuilt 2001 · S/N 145517 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 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 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 N612AEAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145079 N613AEAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145081

Back to AD 2015-02-13