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.

N877RWRed Wing Shoe Company Inc · Red Wing, MNBuilt 2012 · S/N 560-6123 N877SBSb Companies LLC · San Antonio, TXBuilt 2017 · S/N 5555 N877SVBank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 145789 N877UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 2232 N878DBThorondor LLC · Palo Alto, CAFirst renewal noticeBuilt 2007 · S/N 5167 N878FDFederal Express Corp · Memphis, TNBuilt 2017 · S/N 40684 N878GCGraton Economic Development Authority · Rohnert Park, CABuilt 2003 · S/N 5025 N878TPP W Feentra Construction Inc · Queen Creek, AZBuilt 2023 · S/N 2334 N878UAUnited Airlines Inc · Chicago, ILBuilt 2005 · S/N 2371 N879FDFederal Express Corp · Memphis, TNBuilt 2018 · S/N 40685 N879STPennsylvania State Police · Hershey, PABuilt 2015 · S/N 1536 N879UAUnited Airlines Inc · Chicago, ILBuilt 2005 · S/N 2408 N87BCCalhoun Aviation LLC · Fairfield, TXBuilt 2009 · S/N 1136 N87BEOrion Aviation LLC · Jeffersonville, INBuilt 2011 · S/N 560-6087 N87NGAky Transportation LLC · Oklahoma City, OKBuilt 2019 · S/N 1887 N87NSSeaman Corporation · Wooster, OHBuilt 2001 · S/N 560-5213 N87SJAir Biggie LLC · Bristol, VABuilt 2010 · S/N 57023 N87SKSmm Aviation 1 LLC · Oklahoma City, OKBuilt 2006 · S/N 317 N87WUBarristair Lc · Beaumont, TXBuilt 1999 · S/N 560-5039 N880AGBai-Oil & Gas Ltd Co · Albuquerque, NMS/N 1102 N880CHEcho Acquisitions LLC · Dover, DES/N 168 N880ECDodson International Parts Inc · Rantoul, KSS/N 56 N880POp Aviation LLC · Seattle, WABuilt 2004 · S/N 560-5364 N880SRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 5426 N880UAUnited Airlines Inc · Chicago, ILBuilt 2005 · S/N 2426 N881ABTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 1502 N881ADDna Air LLC · Wilmington, DEBuilt 2001 · S/N 136 N881FGTributary Aviation LLC · Paradise Valley, AZBuilt 2008 · S/N 1026 N881MJKalitta Charters LLC · Ypsilanti, MIBuilt 2000 · S/N 076 N881NGBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 1881 N881UAUnited Airlines Inc · Chicago, ILBuilt 2005 · S/N 2435 N881VPCitation Technology Partners LLC · Woodside, CABuilt 2009 · S/N 560-6018 N882ACBd Advisors LLC · Beaumont, TXBuilt 2004 · S/N 145770 N882ADDna Air LLC · Wilmington, DEBuilt 2002 · S/N 185 N882AFCsw Aviation LLC · Portsmouth, NHBuilt 2019 · S/N 1882 N882CAPere Marquette Group LLC · Grand Rapids, MIBuilt 2001 · S/N 155 N882DEEco Aviation LLC · Coral Gables, FLBuilt 2011 · S/N 4233 N882PXNewage Aviation I LLC · Arcadia, CABuilt 2004 · S/N 5015 N882RRCapital Holdings 238 LLC · Waco, TXBuilt 2023 · S/N 2243 N882UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2505 N882WRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 5576 N883AFunair Corp · Aventura, FLBuilt 2007 · S/N 5175 N883AATeatree LLC · Incline Village, NVBuilt 2009 · S/N 1177 N883CCWildcats LLC · Westerly, RIBuilt 2021 · S/N 2094 N883PFPrestage Farms Inc · Clinton, NCBuilt 2010 · S/N 560-6053 N883SCBuffalo Bayou Air LLC · Houston, TXBuilt 2000 · S/N 560-5124 N883SJBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 5279 N883UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2574 N884BFriendly Skies 2 LLC · Muncie, INBuilt 2001 · S/N 560-5140 N884BBHf III LLC · Saint Paul, MNBuilt 1987 · S/N 17

Back to AD 2012-26-15 R1