Skip to content

Registered aircraft · 204

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:96-18-08-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:96-18-08-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:96-18-08-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:96-18-08-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:96-18-08-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:96-18-08-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 N757QMAero Micronesia Inc DBA · Barrigada, GUBuilt 1994 · S/N 27203 N758SSRed River Aircraft Leasing LLC · Anchorage, AKBuilt 1992 · S/N 26647 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 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 N819DXDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 33959 N820DXDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 33960 N821DXDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 33961 N822DXDelta Air Lines Inc · Atlanta, GABuilt 2005 · S/N 33966 N823DXDelta Air Lines Inc · Atlanta, GABuilt 2005 · S/N 33967 N888LTAero Micronesia Inc DBA · Barrigada, GUBuilt 1992 · S/N 25441 N900PCDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28446 N922TSAero Micronesia Inc DBA · Barrigada, GUBuilt 1990 · S/N 24845 N985FDFederal Express Corp · Memphis, TNBuilt 1990 · S/N 24737 N986FDFederal Express Corp · Memphis, TNBuilt 1997 · S/N 28482 N987FDFederal Express Corp · Memphis, TNBuilt 1997 · S/N 28483 N988FDFederal Express Corp · Memphis, TNBuilt 1993 · S/N 26705 N989FDFederal Express Corp · Memphis, TNBuilt 1997 · S/N 28480 N992FDFederal Express Corp · Memphis, TNBuilt 1986 · S/N 22912 N993FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 24965 N995FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 25131 N996FDFederal Express Corp · Memphis, TNBuilt 1993 · S/N 26270

Back to AD 96-18-08 R1