Skip to content

Registered aircraft · 896

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:85-14-02-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:85-14-02-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:85-14-02-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:85-14-02-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:85-14-02-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:85-14-02-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.

N379UPCc&E I LLC · Louisville, KYBuilt 2023 · S/N 67968 N380UPCc&E I LLC · Louisville, KYBuilt 2023 · S/N 67969 N381UPC C & E I LLC · Louisville, KYBuilt 2023 · S/N 67970 N382UPC C & E I LLC · Louisville, KYBuilt 2023 · S/N 67971 N383UPCc & Ei LLC · Louisville, KYBuilt 2023 · S/N 67972 N384UPC C & E I LLC · Louisville, KYBuilt 2024 · S/N 67973 N385UPC C & E I LLC · Louisville, KYBuilt 2024 · S/N 67974 N386UPC C & E I LLC · Louisville, KYBuilt 2024 · S/N 67975 N387UPC C & E I LLC · Louisville, KYBuilt 2024 · S/N 67976 N388UPC.C. & E.I LLC · Louisville, KYBuilt 2025 · S/N 67977 N389AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 26915 N389UPUnited Parcel Service Co · Louisville, KYBuilt 2025 · S/N 67978 N390CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2002 · S/N 32973 N390UPUnited Parcel Service Co · Louisville, KYBuilt 2025 · S/N 67979 N391CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2002 · S/N 32975 N391UPCargo Aircraft Management Inc · Wilmington, OHS/N 28039 N392UPCargo Aircraft Management Inc · Wilmington, OHBuilt 1996 · S/N 28041 N393UPCargo Aircraft Management Inc · Wilmington, OHBuilt 1998 · S/N 29228 N394UPCargo Aircraft Management Inc · Wilmington, OHBuilt 1991 · S/N 25136 N395CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25447 N395UPCargo Aircraft Management Inc · Wilmington, OHBuilt 1998 · S/N 29229 N396CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1991 · S/N 25195 N396UPUnited Parcel Service Co · Louisville, KYBuilt 2010 · S/N 40364 N397AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1988 · S/N 24035 N397UPUnited Parcel Service Co · Louisville, KYBuilt 2010 · S/N 40363 N404KZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 34283 N405KZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 36132 N406KZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 36133 N41135United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29284 N41140United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30353 N413CMCargo Aircraft Management Inc · Wilmington, OHS/N 26988 N418LACernicalo Leasing LLC · Wilmington, DEBuilt 2005 · S/N 34246 N419AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1994 · S/N 26913 N420LACaiquen Leasing LLC · Wilmington, DEBuilt 2006 · S/N 34627 N423AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1996 · S/N 27569 N429MCAtlas Air Inc · Purchase, NYBuilt 1990 · S/N 24833 N430FEFederal Express Corp · Memphis, TNBuilt 1985 · S/N 394 N431AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1989 · S/N 24632 N431FEFederal Express Corp · Memphis, TNBuilt 1984 · S/N 316 N432AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 27449 N433AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1989 · S/N 24400 N438GTAtlas Air Inc · White Plains, NYBuilt 2002 · S/N 30766 N439GTAtlas Air Inc · White Plains, NYBuilt 2002 · S/N 30767 N443AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25202 N453FEFederal Express Corp · Memphis, TNBuilt 1983 · S/N 267 N454FEFederal Express Corp · Memphis, TNBuilt 1983 · S/N 278 N455CMCargo Aircraft Management Inc · Wilmington, OHS/N 26983 N457AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1993 · S/N 25448 N462CMN462cm Inc · Wilmington, DENon-citizen corporation, flight hours not reportedS/N 26985 N464MCAtlas Air Inc · Purchase, NYBuilt 1992 · S/N 26341

Back to AD 85-14-02 R2