Skip to content

Registered aircraft · 456

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:93-05-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:93-05-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:93-05-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:93-05-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:93-05-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:93-05-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.

N190DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28447 N190FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 63121 N191DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28448 N191FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 63122 N192DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28449 N192FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 63123 N193DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28450 N193FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 63124 N194DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28451 N194UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26892 N195DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28452 N195FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 63125 N195UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26899 N196DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28453 N196FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 63126 N197DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28454 N197FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 63127 N197UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26901 N198DNDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 28455 N198FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 63128 N199DNDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 28456 N199FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 63129 N207AXOmni Planes LLC · Tulsa, OKBuilt 2001 · S/N 30438 N219CYCargo Aircraft Management Inc · Wilmington, OHBuilt 1989 · S/N 24358 N225AXOmni Planes LLC · Tulsa, OKBuilt 2001 · S/N 30434 N225NE2/25/94 LLC · Foxboro, MABuilt 1991 · S/N 25194 N227AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 27448 N227CYCargo Aircraft Management Inc · Wilmington, OHBuilt 1996 · S/N 26327 N229AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1994 · S/N 27059 N233AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1998 · S/N 29430 N234AXCargo Aircraft Management Inc · Wilmington, OHBuilt 2001 · S/N 30436 N237CMCargo Aircraft Management Inc · Wilmington, OHS/N 25584 N239AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 27450 N241AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 27451 N244FEFederal Express Corp · Memphis, TNBuilt 2026 · S/N 67549 N245FEFederal Express Corp · Memphis, TNBuilt 2026 · S/N 67548 N246FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67547 N247FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67546 N248FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67545 N249BABoeing Aircraft Holding Co · Seattle, WAS/N 24309 N249FEFederal Express Corporation · Memphis, TNBuilt 2025 · S/N 67544 N250FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67543 N251FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67542 N252FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67541 N253FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67540 N254FEFederal Express Corp · Memphis, TNBuilt 2024 · S/N 67539 N255CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1984 · S/N 22316 N255FEFederal Express Corporation · Memphis, TNBuilt 2024 · S/N 67538 N256FEFederal Express Corp · Memphis, TNBuilt 2024 · S/N 67537 N257AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1999 · S/N 29605

Back to AD 93-05-13