Skip to content

Registered aircraft · 708

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-R3') 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-R3') 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-R3')
    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-R3')
  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-R3')
  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-R3')
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.

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 N760USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1354

Back to AD 97-09-02 R3