Skip to content

Registered aircraft · 281

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.

N1013AAndromeda Leasing I LLC · Purchase, NYBuilt 1999 · S/N 30110 N102DADelta Air Lines Inc · Atlanta, GABuilt 1982 · S/N 22214 N1049AAndromeda Leasing II LLC · Purchase, NYBuilt 1999 · S/N 30109 N1093AAndromeda Leasing II LLC · Purchase, NYBuilt 1999 · S/N 30111 N111FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 64060 N1361AMsn 26265 LLC · Purchase, NYBuilt 1995 · S/N 26265 N1399AAndromeda Leasing I LLC · Purchase, NYBuilt 1996 · S/N 27959 N1487AAndromeda Leasing I LLC · Purchase, NYBuilt 1997 · S/N 28865 N1602Delta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29694 N1603Delta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29695 N1604RDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30180 N1605Delta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30198 N16065Delta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30199 N171DZDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29690 N172DZDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29691 N173DZDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29692 N174DZDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29693 N175DZDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29696 N176DZDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29697 N177DZDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29698 N178DZDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30596 N207AXCargo Aircraft Management Inc · Wilmington, OHBuilt 2001 · S/N 30438 N225AXCargo Aircraft Management Inc · Wilmington, OHBuilt 2001 · S/N 30434 N225NE2/25/94 LLC · Foxboro, MABuilt 1991 · S/N 25194 N227AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 27448 N229AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1994 · S/N 27059 N234AXCargo Aircraft Management Inc · Wilmington, OHBuilt 2001 · S/N 30436 N239AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 27450 N241AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 27451 N250UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 48745 N251AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1999 · S/N 29604 N251UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 48744 N252UPUnited Parcel Service Co · Louisville, KYBuilt 1996 · S/N 48768 N254UPUnited Parcel Service Co · Louisville, KYBuilt 1993 · S/N 48406 N255UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48404 N256UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48405 N257UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48451 N258SNB29258 LLC · Estero, FLBuilt 1999 · S/N 29258 N258UPUnited Parcel Service Co · Louisville, KYBuilt 1991 · S/N 48416 N260UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48418 N261UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 48805 N262UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 48806 N263UPUnited Parcel Service Co · Louisville, KYBuilt 1998 · S/N 48782 N264UPUnited Parcel Service Co · Louisville, KYBuilt 2000 · S/N 48800 N265UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 48803 N272FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 66242 N301UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 27239 N302UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 27240 N303UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 27241 N304UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 27242

Back to AD 2004-07-13