Skip to content

Registered aircraft · 571

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:2000-13-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:2000-13-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:2000-13-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:2000-13-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:2000-13-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:2000-13-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.

N121ATJea Media Luna Surface Lp · Bearden, ARBuilt 1998 · S/N 750-0057 N12540Dulux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145537 N12552Corporate Flight Management Inc · Smyrna, TNBuilt 2002 · S/N 145583 N125DZCitation X Parts LLC · Liberty, NCBuilt 1999 · S/N 750-0079 N125THCitation X Parts LLC · Liberty, NCBuilt 2002 · S/N 750-0177 N12BA3hba LLC · Dallas, TXBuilt 2004 · S/N 7500222 N12GGLima Golf Investments LLC · Bigfork, MTBuilt 2001 · S/N 750-0140 N13123Delux Public Charter LLC · Dallas, TXBuilt 2003 · S/N 145688 N13124United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145689 N13132United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145708 N13133United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145712 N13161United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500805 N135SGValiair Lc Trustee · Casper, WYBuilt 2003 · S/N 145706 N135SLZed Aerocapital LLC · Dover, DEBuilt 2003 · S/N 145711 N135SXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 145728 N138DEChampion Air LLC · Mooresville, NCS/N 145129 N138SPFixed Gear 2 LLC · Seattle, WABuilt 2000 · S/N 750-0138 N13975Delux Public Charter LLC · Dallas, TXBuilt 1999 · S/N 145163 N13978Delux Public Charter LLC · Dallas, TXBuilt 1999 · S/N 145180 N13979Delux Public Charter LLC · Dallas, TXBuilt 1999 · S/N 145181 N13988Delux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145265 N13989Delux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145271 N13992Delux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145284 N13SYSy Air LLC · Tampa, FLBuilt 2001 · S/N 750-0143 N14105Delux Public Charter LLC · Dallas, TXBuilt 2002 · S/N 145649 N14116United Airlines Inc · Chicago, ILBuilt 2002 · S/N 145672 N14125United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145690 N14143United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145739 N14148United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145751 N14153United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145761 N14158United Airlines Inc · Chicago, ILBuilt 2004 · S/N 145791 N14162United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500808 N14168United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500840 N14173United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500872 N14174United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500876 N14177United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500888 N14179United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500896 N14180United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500900 N14186United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500924 N14188United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500929 N14198United Airlines Inc · Chicago, ILBuilt 2006 · S/N 14500951 N144PAPerfect Agreements Leasing Inc · Trabucco, CABuilt 2003 · S/N 750-0224 N14542Delux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145547 N145DBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 14501045 N14904Delux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145477 N14916Delux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145415 N14933Spectre Air Capital LLC · Horseshoe Bay, TXBuilt 1997 · S/N 145018 N151SBVandelay America LLC · Newport Beach, CABuilt 2000 · S/N 750-0108 N15509Corporate Flight Management Inc · Smyrna, TNBuilt 2000 · S/N 145238 N15527Corporate Flight Management Inc · Smyrna, TNBuilt 2001 · S/N 145413

Back to AD 2000-13-01