Skip to content

Registered aircraft · 271

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:91-23-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:91-23-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:91-23-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:91-23-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:91-23-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:91-23-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.

N102DADelta Air Lines Inc · Atlanta, GABuilt 1982 · S/N 22214 N111FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 64060 N120JMSouth Aircraft Leasing Inc · Wilmington, DEBuilt 1988 · S/N 48311 N1361AMsn 26265 LLC · Purchase, NYBuilt 1995 · S/N 26265 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 N17085Bc Aircraft Leasing LLC · Albuquerque, NMBuilt 1975 · S/N 47957 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 N235ULAircraft Endeavors LLC · San Antonio, TXBuilt 1976 · S/N 46956 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 N255CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1984 · S/N 22316 N255UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48404 N256UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48405 N258SNB29258 LLC · Estero, FLBuilt 1999 · S/N 29258 N264DEAircraft Endeavors LLC · San Antonio, TXBuilt 1978 · S/N 46985 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 N303FEFederal Express Corporation · Memphis, TNBuilt 1973 · S/N 46802 N303UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 27241 N304FEFederal Express Corporation · Memphis, TNBuilt 1978 · S/N 46992 N304UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 27242 N305UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 27243 N306FEFederal Express Corp · Memphis, TNBuilt 1985 · S/N 48287 N306UPUnited Parcel Service Co · Louisville, KYBuilt 1996 · S/N 27759 N307FEFederal Express Corp · Memphis, TNBuilt 1986 · S/N 48291 N307UPUnited Parcel Service Co · Louisville, KYBuilt 1996 · S/N 27760 N308FEFederal Express Corp · Memphis, TNBuilt 1986 · S/N 48297

Back to AD 91-23-13