Skip to content

Registered aircraft · 282

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:2004-07-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-07-13') 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:2004-07-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-07-13')
  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:2004-07-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-07-13')
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.

N304UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 27242 N305UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 27243 N306UPUnited Parcel Service Co · Louisville, KYBuilt 1996 · S/N 27759 N307UPUnited Parcel Service Co · Louisville, KYBuilt 1996 · S/N 27760 N308UPUnited Parcel Service Co · Louisville, KYBuilt 1996 · S/N 27761 N309UPUnited Parcel Service Co · Louisville, KYBuilt 1996 · S/N 27740 N310UPUnited Parcel Service Co · Louisville, KYBuilt 1996 · S/N 27762 N311UPUnited Parcel Service Co · Louisville, KYBuilt 1996 · S/N 27741 N313UPC C & E I LLC · Louisville, KYBuilt 1996 · S/N 27764 N314UPC C & E I LLC · Louisville, KYBuilt 1996 · S/N 27742 N315UPC C & E I LLC · Louisville, KYBuilt 1996 · S/N 27743 N316UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 27744 N317AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25445 N317UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 27745 N318UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 27746 N319CMCargo Aircraft Management Inc · Wilmington, OHS/N 24407 N319UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 27758 N320UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 27747 N322UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 27748 N323UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 27749 N324UPUnited Parcel Service Co · Louisville, KYBuilt 1998 · S/N 27750 N325UPUnited Parcel Service Co · Louisville, KYBuilt 1998 · S/N 27751 N326UPUnited Parcel Service Co · Louisville, KYBuilt 1998 · S/N 27752 N327UPC C & E I LLC · Louisville, KYBuilt 1998 · S/N 27753 N329UPUnited Parcel Service Co · Louisville, KYBuilt 1999 · S/N 27755 N329ZAKalitta Air LLC · Ypsilanti, MIBuilt 2003 · S/N 32914 N330UPC C & E I LLC · Louisville, KYBuilt 1999 · S/N 27756 N331UPUnited Parcel Service Co · Louisville, KYBuilt 1999 · S/N 27757 N332UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 32843 N334UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 32844 N337AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1994 · S/N 27060 N344KDAtares Funding LLC · Miami Beach, FLBuilt 1992 · S/N 26344 N349CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1993 · S/N 26996 N353AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25198 N36NE2/25/94 LLC · Foxboro, MABuilt 1991 · S/N 25193 N378CXCargo Aircraft Management Inc · Wilmington, OHBuilt 1994 · S/N 27184 N392UPCargo Aircraft Management Inc · Wilmington, OHBuilt 1996 · S/N 28041 N393UPCargo Aircraft Management Inc · Wilmington, OHBuilt 1998 · S/N 29228 N395CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25447 N396CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1991 · S/N 25195 N397AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1988 · S/N 24035 N404KZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 34283 N406KZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 36133 N408MCAtlas Air Inc · Purchase, NYBuilt 1998 · S/N 29261 N409AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1990 · S/N 24983 N409MCAtlas Air Inc · Purchase, NYBuilt 2000 · S/N 30558 N411SNAtares Funding LLC · Fisher Island, FLBuilt 1990 · S/N 48411 N412MCAtlas Air Inc · White Plains, NYBuilt 2000 · S/N 30559 N412SNM48412 LLC · Estero, FLBuilt 1990 · S/N 48412 N415JNAtares Funding LLC · Fisher Island, FLS/N 48415

Back to AD 2004-07-13