Skip to content

Registered aircraft · 709

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

N723UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 1109 N72405United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30122 N724UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 1122 N725UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 1135 N726SWSouthwest Airlines Co · Dallas, TXBuilt 1999 · S/N 27858 N730USAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 1182 N73251United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30582 N73256United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30611 N73259United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30803 N73270United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31632 N73275United Airlines Inc · Chicago, ILBuilt 2002 · S/N 31593 N73283Umb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 31606 N73291Umb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 33454 N73299United Airlines Inc · Chicago, ILBuilt 2005 · S/N 34005 N732USAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 1203 N733UWAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 1205 N73406United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30123 N7352CCsds Asset Management LLC · Rllng Hls Est, CAS/N 26340 N735EDynamic Aviation Group Inc · Bridgewater, VAS/N 26339 N737AGFunair Corp · Aventura, FLBuilt 1999 · S/N 30496 N737CGCoulson Aviation (USA) Inc · Portland, ORBuilt 1995 · S/N 27954 N737CMWren Acquisitions LLC · Birmingham, MIBuilt 1999 · S/N 30327 N737JBWi Bbj LLC · Mequon, WIBuilt 2000 · S/N 30572 N737KRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 29791 N737MCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2002 · S/N 33361 N737USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1245 N738AU S Marshals Service · Oklahoma City, OKBuilt 2000 · S/N 30182 N738USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1254 N740UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1265 N741UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1269 N742PSBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1275 N744PBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1287 N745VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1289 N746UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1297 N747UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1301 N748UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1311 N749SWSouthwest Airlines Co · Dallas, TXBuilt 1999 · S/N 29801 N749USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1313 N750UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1315 N751UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1317 N752USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1319 N753USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1326 N75410United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30127 N754UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1328 N755USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1331 N756USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1340 N757LVSouthwest Airlines Co · Dallas, TXBuilt 1999 · S/N 29850 N757UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1342 N758USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1348 N7600KSas Institute Inc · Cary, NCBuilt 2001 · S/N 32628

Back to AD 97-09-02 R2