Skip to content

Registered aircraft · 245

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:94-01-10-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:94-01-10-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:94-01-10-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:94-01-10-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:94-01-10-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:94-01-10-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.

N711ZXDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28481 N717TWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 28485 N718TWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 28486 N721TWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29954 N722TWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29385 N723TWDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29378 N724TWR&W Flying Inc · Greenbrier, ARS/N 28488 N727TWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30340 N752CXCargo Aircraft Management Inc · Wilmington, OHS/N 24451 N752LTL-3 Communications Advanced Aviation LLC · Kalispell, MTS/N 26058 N755CSCsds Asset Management LLC · Rllng Hls Est, CAS/N 25014 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 N758SSRed River Aircraft Leasing LLC · Anchorage, AKBuilt 1992 · S/N 26647 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 N773FDFederal Express Corp · Memphis, TNBuilt 1990 · S/N 24872 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 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 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 N793FDFederal Express Corp · Memphis, TNBuilt 1993 · S/N 26698 N794FDFederal Express Corp · Memphis, TNBuilt 1993 · S/N 26701 N795FDFederal Express Corp · Memphis, TNBuilt 1993 · S/N 26706 N796FDFederal Express Corp · Memphis, TNBuilt 1993 · S/N 26710 N797FDFederal Express Corp · Memphis, TNBuilt 1996 · S/N 28143 N798FDFederal Express Corp · Memphis, TNBuilt 1996 · S/N 28144 N799FDFederal Express Corp · Memphis, TNBuilt 1996 · S/N 28145 N801DMParallel Express LLC · Las Vegas, NVS/N 26240 N818NHAersale Inc · Doral, FLBuilt 2000 · S/N 29311

Back to AD 94-01-10 R2