Registered aircraft · 5,537

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:2012-26-15-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:2012-26-15-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:2012-26-15-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:2012-26-15-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:2012-26-15-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:2012-26-15-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.

N1919Phase 2 Aviation LLC · Miami, FLBuilt 2019 · S/N 1919 N191DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28448 N191FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 63122 N191LJAviation Resource Group Inc · Fort Lauderdale, FLS/N 191 N191NVAllegiant Air LLC · Las Vegas, NVBuilt 2015 · S/N 6704 N191PEJmm Aviation LLC · Oakwood, GABuilt 2010 · S/N 1191 N191PGDw Leasing LLC · Charlotte, NCBuilt 2018 · S/N 1775 N191TDRichards Aviation Inc · Memphis, TNBuilt 2006 · S/N 298 N191UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 1447 N1921UBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 2104 N1925PRegistered aircraftBuilt 2009 · S/N 402 N1929YFalcon084 LLC · Wilmington, DEBuilt 1999 · S/N 84 N192CPaso Aviation LLC · Winsted, MNBuilt 2024 · S/N 2403 N192CPRegistered aircraftBuilt 2014 · S/N 1509 N192DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28449 N192FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 63123 N192HAWhite Diamond Row LLC · Hackett, ARBuilt 1998 · S/N 061 N192NCScp Aviation LLC · Boca Raton, FLBuilt 2008 · S/N 4126 N192NVAllegiant Air LLC · Las Vegas, NVBuilt 2015 · S/N 6787 N192RSR&S Aviation Inc · Rancho Cucamonga, CABuilt 1995 · S/N 143 N192UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 1496 N1932A H Beck Foundation Co Inc · Converse, TXBuilt 2007 · S/N 2082 N1932HAirmax LLC · Waukee, IABuilt 2023 · S/N 2260 N1932PMozart Investments Inc · Roanoke, VABuilt 2016 · S/N 5549 N193DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28450 N193FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 63124 N193NVAllegiant Air LLC · Las Vegas, NVBuilt 2015 · S/N 6835 N193UWAmerican Airlines Inc · Fort Worth, TXBuilt 2008 · S/N 3584 N194DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28451 N194NTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 534 N194NVAllegiant Air LLC · Las Vegas, NVBuilt 2015 · S/N 6889 N194UWAmerican Airlines Inc · Fort Worth, TXS/N 3629 N195AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5195 N195DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28452 N195FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 63125 N195NVAllegiant Air LLC · Las Vegas, NVBuilt 2016 · S/N 6939 N195PGBank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N 1953 N195UWAmerican Airlines Inc · Fort Worth, TXBuilt 2008 · S/N 3633 N1963NWater Force One LLC · Diamond Bar, CABuilt 2012 · S/N 4268 N1964MTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 5558 N196CCPhoenix Nap Management Resources LLC · Phoenix, AZBuilt 2004 · S/N 4005 N196DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28453 N196FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 63126 N196NVAllegiant Air LLC · Las Vegas, NVBuilt 2016 · S/N 6965 N196SBTexas Citation S II Management LLC · San Antonio, TXBuilt 2004 · S/N 560-5513 N196UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3879 N197DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28454 N197ECTeam Aero LLC · Shawnee, KSS/N 197 N197FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 63127 N197NVAllegiant Air LLC · Las Vegas, NVBuilt 2016 · S/N 7063

Back to AD 2012-26-15 R1