Skip to content

Registered aircraft · 680

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:89-26-06-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:89-26-06-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:89-26-06-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:89-26-06-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:89-26-06-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:89-26-06-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.

N757ABoeing Logistics Spares Inc · Seattle, WABuilt 1982 · S/N 22212 N757AFDjt Operations I LLC · West Palm Beach, FLBuilt 1991 · S/N 25155 N757HWHoneywell Aerospace US LLC · Phoenix, AZBuilt 1982 · S/N 22194 N757SSRed River Aircraft Leasing LLC · Anchorage, AKBuilt 1983 · S/N 22176 N75851United Airlines Inc · Chicago, ILBuilt 2001 · S/N 32810 N75853United Airlines Inc · Chicago, ILBuilt 2002 · S/N 32812 N75854United Airlines Inc · Chicago, ILBuilt 2002 · S/N 32813 N75858United Airlines Inc · Chicago, ILBuilt 2004 · S/N 32817 N758SSRed River Aircraft Leasing LLC · Anchorage, AKBuilt 1992 · S/N 26647 N760CKKalitta Air LLC · Ypsilanti, MIBuilt 1990 · S/N 24753 N761CKKalitta Air LLC · Ypsilanti, MIBuilt 1989 · S/N 24752 N761CXCargo Aircraft Management Inc · Wilmington, OHBuilt 1985 · S/N 22318 N7672CBank Of Utah Trustee · Salt Lake City, UTS/N 30432 N7672DBank Of Utah Trustee · Salt Lake City, UTS/N 30433 N7673CCsds Asset Management LLC · Rllng Hls Est, CAS/N 28264 N767AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1983 · S/N 22785 N767BZBank Of Utah Trustee · Salt Lake City, UTS/N 22567 N767MWWyatt Aerospace LLC · Chandler, AZBuilt 1982 · S/N 22694 N768AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1983 · S/N 22786 N768VACargo Aircraft Management Inc · Wilmington, OHBuilt 1982 · S/N 21869 N770BBYucaipa Companies LLC · Burbank, CABuilt 1991 · S/N 25220 N770FDFederal Express Corp · Memphis, TNBuilt 1990 · S/N 24743 N771FDFederal Express Corp · Memphis, TNBuilt 1990 · S/N 24799 N772FDFederal Express Corp · Memphis, TNBuilt 1990 · S/N 24840 N773AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1983 · S/N 22788 N773FDFederal Express Corp · Memphis, TNBuilt 1990 · S/N 24872 N774AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1983 · S/N 22789 N774FDFederal Express Corp · Memphis, TNBuilt 1993 · S/N 26709 N775FDFederal Express Corp · Memphis, TNBuilt 1991 · S/N 25043 N776FDFederal Express Corp · Memphis, TNBuilt 1991 · S/N 25129 N777FDFederal Express Corp · Memphis, TNBuilt 1991 · S/N 25222 N778FDFederal Express Corp · Memphis, TNBuilt 1991 · S/N 25223 N779FDFederal Express Corp · Memphis, TNBuilt 1991 · S/N 25252 N780FDFederal Express Corp · Memphis, TNBuilt 1991 · S/N 25253 N781FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 26673 N782FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 26677 N783AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1984 · S/N 23016 N783CKKalitta Air LLC · Ypsilanti, MIBuilt 1990 · S/N 24782 N783FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 26678 N783SPKalitta Charters II LLC · Ypsilanti, MIBuilt 1985 · S/N 22611 N784FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 26681 N785FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 26682 N786FDFederal Express Corp · Memphis, TNBuilt 1991 · S/N 24995 N787CKKalitta Air LLC · Ypsilanti, MIBuilt 1997 · S/N 28838 N787FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 26685 N788FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 26686 N789FDFederal Express Corp · Memphis, TNBuilt 1993 · S/N 26689 N790FDFederal Express Corp · Memphis, TNBuilt 1993 · S/N 26693 N791FDFederal Express Corp · Memphis, TNBuilt 1993 · S/N 26694 N792FDFederal Express Corp · Memphis, TNBuilt 1993 · S/N 26697

Back to AD 89-26-06 R1