AD 2012-10-13

Registered aircraft · 13,306

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.

N7478Hubbard Matthew L · Phoenix, AZBuilt 2002 · S/N 0420N747ASRooks Peter L · Andover, MABuilt 2022 · S/N 8998N747CTN747ct LLC · Mayfield, KYBuilt 2017 · S/N 4485N747CWDynamic Engineering Inc · Van Buren, ARBuilt 2005 · S/N 41509N747DVUnrestricted Climb LLC · Muskego, WIBuilt 1996 · S/N E-3062N747DWAviation Trust Company LLC Trustee · Oklahoma City, OKS/N TH-2002N747GLoblolly Management LLC · Concord, NCBuilt 1998 · S/N E-3203N747LJEichleay Peter · Yarmouth, MES/N 0535N747LLSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2003 · S/N 0496N747MBMaitland Egerton M Jr Dr · Lexington, SCBuilt 2008 · S/N 2913N747MCCirrus Sr22t Mmc 2285 Inc Trustee · Wilmington, DEBuilt 2021 · S/N 2285N747PHFirst State Bancshares Inc · Middleberg, KYFirst renewal noticeBuilt 1988 · S/N TH-1533N747PJOsprey Capital LLC · Winston Salem, NCBuilt 2005 · S/N 1483N747PLSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2007 · S/N 2289N747SBCloud Transport Operations LLC · Kalispell, MTBuilt 1980 · S/N TJ-297N747SDAvitrans Inc · Cypress, CABuilt 2006 · S/N 2245N747SJBuell Steven M · Fisherville, KYBuilt 2001 · S/N 0091N747SLWesley Kelley · Pontotoc, MSBuilt 2006 · S/N 42550N747SWJet Air Inc · Iowa City, IAS/N 1370N747TGValiair Ltd Co Trustee · Casper, WYBuilt 2003 · S/N 0718N747TTDogbolter Aviation LLC · Milwaukee, WIBuilt 2003 · S/N 0481N747VPSavfar Aviation Inc · Wilmington, DEBuilt 2005 · S/N 41092N747WSHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0080N747YVGreat Among The Nations Inc · Beverly Hills, CABuilt 1999 · S/N EA-642N7485QEvans Charles H Trustee · Hooksett, NHBuilt 1973 · S/N U20602220N748CDPinkgg LLC · Marathon, FLBuilt 2001 · S/N 0086N748CMFox Creek Aviation LLC · Los Gatos, CABuilt 2017 · S/N 1511N748DCHorizon Products LLC · Las Vegas, NVBuilt 2020 · S/N 2220N748JARegistration Pending · Phoenix, AZRegistration pendingBuilt 2024 · S/N 9786N748MGEl Paso Aero Inc · El Paso, TXBuilt 1974 · S/N T310Q1128N749BSPropeller Aircraft Holdings LLC · Everett, WABuilt 2020 · S/N 2089N749CDGoat Island Films Inc · Covina, CABuilt 2001 · S/N 0099N749JBSkylands Group LLC · Wilmington, DES/N 41511N749PGSfly LLC · Dubuque, IABuilt 2005 · S/N 1339N749RBAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2017 · S/N 1574N749RCChadwick Michael · Reston, VABuilt 2004 · S/N 1044N749SPNew York State Police · Latham, NYBuilt 1986 · S/N U20606957N74AGMarion Pilots Club Inc · Marion, INBuilt 2002 · S/N 0428N74BRBbj Aviators LLC · Springfield, ILBuilt 1997 · S/N E-3106N74BYMav & Merlin Aviation LLC · Columbia, SCBuilt 2014 · S/N 0892N74CRCage Presnall C · Falfurrias, TXBuilt 2003 · S/N 40061N74CWN74cw LLC · Sandy, UTBuilt 2025 · S/N 10655N74DTEnjoy Life Flying LLC · Sunrise, FLBuilt 1999 · S/N EA-634N74DXKendrick Jeffrey Joseph II · Hayden Lake, IDBuilt 2020 · S/N 2187N74ESValiair Ltd Co Trustee · Casper, WYBuilt 1979 · S/N P21000279N74FBBurns Fred J · Hampstead, NCBuilt 2002 · S/N 0257N74FXGeorgia Screen Rooms LLC · Wilmington, DEBuilt 2007 · S/N L2K-283N74GPPapa Tango LLC · Sioux Falls, SDBuilt 2009 · S/N 3RX-165N74HJRegistration Pending · Sheridan, WYRegistration pendingBuilt 1974 · S/N 340-0333N74KVAerodhooth Kilo-Victor LLC · Acton, MABuilt 2024 · S/N 10049
Back to AD 2012-10-13