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.

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 N24089Ploutz Lloyd · Modesto, CAS/N 20455 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 N253GCAerway Capital Management LLC · Waterford, WIS/N 25303 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 N257FEFederal Express Corp · Memphis, TNBuilt 2024 · S/N 67536 N258FEFederal Express Corp · Memphis, TNBuilt 2024 · S/N 67535 N259FEFederal Express Corp · Memphis, TNBuilt 2024 · S/N 67534 N260FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 67533 N261FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 67532 N262FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 67531 N263FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 67530 N263LMVent Airlines Inc · Dover, DEBuilt 1994 · S/N 26603 N263SGAtlas Air Inc · Purchase, NYBuilt 1999 · S/N 29263 N264FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 66869 N265FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 66868 N266FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 66867 N267FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 66866 N267JRKnight Sky II LLC · Miami, FLBuilt 1986 · S/N 23402 N268FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 66865 N269CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 25586 N269FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66864 N27015United Airlines Inc · Chicago, ILBuilt 2000 · S/N 28678 N270FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 66249 N271FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 66250 N272FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 66242 N272JMAlta 777 LLC · Salt Lake City, UTS/N 27652 N273FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 66243 N274FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 66244 N275FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66245 N276FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66251 N276JMAlta 777 LLC · Salt Lake City, UTS/N 27636 N277FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66246

Back to AD 98-13-12 R1