Skip to content

Registered aircraft · 2,065

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

N100LRMeh1064 LLC · Dover, DEBuilt 1982 · S/N 1064 N1013AAndromeda Leasing I LLC · Purchase, NYBuilt 1999 · S/N 30110 N101FEFederal Express Corp · Memphis, TNBuilt 2013 · S/N 42706 N102DADelta Air Lines Inc · Atlanta, GABuilt 1982 · S/N 22214 N102FEFederal Express Corp · Memphis, TNBuilt 2013 · S/N 42707 N102UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1998 · S/N 0844 N103FEFederal Express Corp · Memphis, TNBuilt 2013 · S/N 43544 N103USUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 0861 N1049AAndromeda Leasing II LLC · Purchase, NYBuilt 1999 · S/N 30109 N104HRXyrec Inc · San Antonio, TXNon-citizen corporation, flight hours not reportedS/N 21525 N104UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 0863 N105FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 64055 N105RHJem Aviation Solutions LLC · South River, NJBuilt 1984 · S/N 650-0055 N105UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 0868 N106FEFederal Express Corp · Memphis, TNBuilt 2014 · S/N 42709 N106PGGreco Equipment Leasing LLC · Bartlett, ILBuilt 1993 · S/N 650-7012 N107FEFederal Express Corp · Memphis, TNBuilt 2014 · S/N 44377 N107USAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1052 N108ADMarquez Padilla Inc · Bonita, CABuilt 1983 · S/N 1080 N108FEFederal Express Corp · Memphis, TNBuilt 2014 · S/N 44378 N108MSYona Aviation II LLC · Las Vegas, NVBuilt 2002 · S/N 33102 N108UWAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1061 N1093AAndromeda Leasing II LLC · Purchase, NYBuilt 1999 · S/N 30111 N109FEFederal Express Corp · Memphis, TNBuilt 2014 · S/N 42710 N109UWAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1065 N110FEFederal Express Corp · Memphis, TNBuilt 2014 · S/N 43542 N110UWAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1112 N111FFabair LLC · Milwaukee, WIBuilt 1991 · S/N 650-0197 N111FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 64060 N111USAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1114 N111YWN111yw LLC · Houston, TXBuilt 1993 · S/N 650-0223 N11206United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30578 N11288Fly The Coop Aviation LLC · Willow Park, TXBuilt 1990 · S/N 650-0184 N112FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 43543 N112USAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1134 N113FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 42711 N114FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 42712 N114UWAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1148 N115FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 42713 N116MBTvpx Ars Inc Trustee · North Salt Lake, UTS/N 650-7081 N117BGJohnson Calvin · Fort Lauderdale, FLBuilt 1983 · S/N 650-0007 N117FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 44379 N117UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1224 N118FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 42714 N118MMBradley Flight LLC · Denver, COBuilt 1999 · S/N 650-7105 N118USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1264 N119FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 64057 N119NAUnited States Government · Washington, DCBuilt 1989 · S/N 24487 N119USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1268 N1200KDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 28457

Back to AD 2002-22-12