Skip to content

Registered aircraft · 182

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-06-13-R1') 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-06-13-R1') 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-06-13-R1')
    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-06-13-R1')
  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-06-13-R1')
  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-06-13-R1')
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.

N670AABank Of Utah Trustee · Salt Lake City, UTBuilt 1992 · S/N 25335 N67134United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29283 N681AABank Of Utah Trustee · Salt Lake City, UTBuilt 1992 · S/N 25338 N686AABank Of Utah Trustee · Salt Lake City, UTBuilt 1992 · S/N 25343 N692AAAersale Inc · Doral, FLBuilt 1993 · S/N 26972 N694ANBank Of Utah Trustee · Salt Lake City, UTBuilt 1994 · S/N 26974 N696ANBank Of Utah Trustee · Salt Lake City, UTBuilt 1994 · S/N 26976 N697ANBank Of Utah Trustee · Salt Lake City, UTBuilt 1994 · S/N 26977 N73860United Airlines Inc · Chicago, ILBuilt 2001 · S/N 32584 N74856United Airlines Inc · Chicago, ILBuilt 2004 · S/N 32815 N750ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30259 N751ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30798 N752ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30260 N753ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30261 N754ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30262 N755ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30263 N756AMAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30264 N757AFDjt Operations I LLC · West Palm Beach, FLBuilt 1991 · S/N 25155 N757ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 32636 N757CJBank Of Utah Trustee · Salt Lake City, UTBuilt 1990 · S/N 24923 N757SSRed River Aircraft Leasing LLC · Anchorage, AKBuilt 1983 · S/N 22176 N75858United Airlines Inc · Chicago, ILBuilt 2004 · S/N 32817 N75861United Airlines Inc · Chicago, ILBuilt 2001 · S/N 32585 N758ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 32637 N759ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 32638 N760ANAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 31477 N762ANAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 31479 N765ANAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 32879 N766ANAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 32880 N770ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29578 N770BBYucaipa Companies LLC · Burbank, CABuilt 1991 · S/N 25220 N771ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29579 N772ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29580 N773ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29583 N774ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29581 N775ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29584 N776ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29582 N777ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29585 N77867United Airlines Inc · Chicago, ILBuilt 2002 · S/N 32592 N77871United Airlines Inc · Chicago, ILBuilt 2003 · S/N 33526 N778ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29587 N779ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29955 N781ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29586 N782ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30003 N783ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30004 N784ANUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 29588 N785ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30005 N786ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30250 N787ALAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30010 N788ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30011

Back to AD 97-06-13 R1