OpenAirDocs.org
AD 2012-10-13

Registered aircraft · 13,311

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
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-10-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:2012-10-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.

N105LWCan You See Me Now LLC · Dakota Dunes, SDBuilt 2024 · S/N 9852N105PAPeck John A Jr · Shady Shores, TXBuilt 1997 · S/N 29-0107N105PKMendel Aviation LLC · Albuquerque, NMBuilt 2023 · S/N 9235N105PZPca Leasing LLC · Heber City, UTBuilt 2009 · S/N L2K-295N105RKEwing John M · Cumming, GABuilt 1979 · S/N TK-104N105TTW&P Aircraft LLC · Humble, TXBuilt 2006 · S/N 1867N105VPSchmitt Lee A · Birmingham, ALBuilt 2002 · S/N 3FX 020N105WLSchmitt Family Holdings LLC · Independence, IABuilt 2006 · S/N 2210N1060RCooper Don F · Great Falls, VABuilt 1996 · S/N E-3040N1061DCcr Aviation LLC · Summit, NJBuilt 1997 · S/N E-3094N1061FFoxtrot Flight LLC · Clarksdale, MSS/N TH-1761N1064CBayside Development LLC · Bellingham, WAS/N TH-1764N1065BRegistered aircraftS/N TH-1765N1065VRegistered aircraftBuilt 1974 · S/N U20602435N1066HBaronhfl LLC · Jacksonville, FLS/N TH-1766N1066PG&K Management Co LLC · Ocala, FLBuilt 1995 · S/N E-3006N1066UBurgoyne Wallace Carr Jr · Spring, TXBuilt 1994 · S/N 29-0005N1068GCanopy Ministries Inc · Mountain City, TNBuilt 2004 · S/N 29-0328N106CAHyannis Air Service Inc · Hyannis, MABuilt 1985 · S/N 402C1020N106EZDannemann Kevin · Wallkill, NYBuilt 2006 · S/N 2044N106JSBlok Air Inc · Brookings, SDBuilt 2018 · S/N 1661N106LBSix Lima Bravo LLC · Geary, OKBuilt 1985 · S/N 46-8508093N106MBBaron Phoenix Aviation LLC · Newport, RIBuilt 2000 · S/N TH-1935N106MCLappland LLC · Camden, DEBuilt 2019 · S/N 1877N106TJN106tj LLC · Murray, UTBuilt 2010 · S/N 3592N106TQRogers Scott · Asheville, NCBuilt 2007 · S/N 2633N1072FGeorgia Air LLC · St Simons Island, GABuilt 1996 · S/N E-3002N1073SAlabama Department Of Transportation · Montgomery, ALBuilt 1996 · S/N TH-1773N1075XFisher Creek Corp · Grove Hill, ALBuilt 1996 · S/N TH-1775N1078SRegistered aircraftBuilt 1996 · S/N TH-1778N107AJAltitude Aviation LLC · West Point, GABuilt 2007 · S/N 2671N107AXCirrusly Flying LLC · Issaquah, WABuilt 2017 · S/N 1519N107BBTer-Bear LLC · Payson, AZBuilt 2016 · S/N 1235N107BCCjw Aviation LLC · San Antonio, TXS/N 3057N107CBR&Dsl Corp Trustee · Wilmington, DEBuilt 2008 · S/N 3244N107FTRoyce Aviation LLC · Greenville, MSS/N 340A0909N107GKYoung William L · Boston, MABuilt 2014 · S/N 0790N107JPPayne Thomas E · Old Forge, NYBuilt 1973 · S/N U20602079N107MTTuch Michael · Gonzales, TXS/N 4846N107MYTeatree LLC · Incline Village, NVBuilt 2018 · S/N 1751N107PBAntler Air LLC · Klamath Falls, ORBuilt 2006 · S/N 2292N107PMHaase Jason M · Hastings, NEBuilt 1986 · S/N 46-8608023N107TGSowder Douglas A · Spokane, WABuilt 2008 · S/N L2K-279N107TQSouthland Air Holdings LLC · Albany, GABuilt 2013 · S/N 3996N1080STacoma Management Inc · Martinsville, VABuilt 1997 · S/N TH-1818N1081YWc LLC · Austin, TXBuilt 1996 · S/N E-3039N1083VWoltering Myron B · Granite Bay, CABuilt 1974 · S/N U20602453N1084PTimothy Duane High · Glenwood, MOBuilt 2000 · S/N LIV-434N1086CTeare Matthew A · Sagamore Hills, OHBuilt 2003 · S/N 0462N1086WThomas R Cave Inc · San Jose, CABuilt 1996 · S/N EA-586
Back to AD 2012-10-13