Skip to content

Registered aircraft · 960

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:98-13-12-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:98-13-12-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:98-13-12-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:98-13-12-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:98-13-12-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:98-13-12-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.

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 N403YKNorthern Air Cargo LLC · Anchorage, AKBuilt 1992 · S/N 25842 N404KZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 34283 N405CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1991 · S/N 25407 N405KZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 36132 N405YKNas Aircraft Leasing Company LLC · Anchorage, AKBuilt 1991 · S/N 25267 N406CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1997 · S/N 28752 N406KZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 36133 N409YKAircraft 25859 LLC · Lake Mary, FLBuilt 1993 · S/N 25859 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 N431AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1989 · S/N 24632 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 N440KHAircraft 28889 LLC · Lake Mary, FLBuilt 1998 · S/N 28889 N442KHAircraft 28888 LLC · Lake Mary, FLBuilt 1998 · S/N 28888 N443AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25202 N444HECsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1987 · S/N 23800 N455CMCargo Aircraft Management Inc · Wilmington, OHS/N 26983 N457AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1993 · S/N 25448

Back to AD 98-13-12 R1