Skip to content

Registered aircraft · 211

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-07-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-07-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-07-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-07-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-07-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-07-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.

N11535Delux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145518 N11536Bank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 145520 N11539Delux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145536 N11565Corporate Flight Management Inc · Smyrna, TNBuilt 2002 · S/N 145621 N12540Dulux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145537 N12552Corporate Flight Management Inc · Smyrna, TNBuilt 2002 · S/N 145583 N138DEChampion Air LLC · Mooresville, NCS/N 145129 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 N14542Delux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145547 N14904Delux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145477 N14916Delux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145415 N15912Delux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145439 N15983Delux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145239 N15VAAdvanced Air LLC · Statesville, NCBuilt 1998 · S/N 145072 N16541Delux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145542 N16981Delux Public Charter LLC · Dallas, TXBuilt 1999 · S/N 145208 N16987Delux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145261 N17984Delux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145246 N215MANewcastle Aviation Partners LLC · Fort Myers, FLS/N 145580 N241JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145391 N242JXDelux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145304 N243JXDelux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145345 N244JXDelux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145331 N245JXDelux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145355 N246JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145443 N247JXDelux Public Charter LLC · Dallas, TXBuilt 2003 · S/N 145763 N25VAAdvanced Air LLC · Statesville, NCBuilt 1999 · S/N 145131 N26549Corporate Flight Management Inc · Smyrna, TNBuilt 2002 · S/N 145571 N290MADodson Parts International Inc · Rantoul, KSS/N 145434 N29917Delux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145414 N376MANewcastle Aviation Partners LLC · Fort Myers, FLS/N 145420 N3DEChampion Air LLC · Mooresville, NCBuilt 2002 · S/N 145626 N410MADodson Parts International Inc · Rantoul, KSS/N 145313 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 N508RHHms Holdings LLC · Charlotte, NCBuilt 2003 · S/N 145769 N509RHHms Holdings LLC · Charlotte, NCBuilt 2001 · S/N 145517 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

Back to AD 2000-07-01