OpenAirDocs.org
AD 2012-16-13

Registered aircraft · 737

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-16-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-16-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.

N816MSSocal Aviation Inc · Eastvale, CABuilt 2019 · S/N 302/USN817SLHall Timothy · Pittston, MEBuilt 2002 · S/N LARSON 54N822SSBresler Andrew · Saint Louis, MOBuilt 2013 · S/N F-12-04-01N8305ALow Wing 12 LLC · Ypsilanti, MIBuilt 2023 · S/N 120071N83VASky High Aviation LLC · Arkadelphia, ARBuilt 2022 · S/N 360/USN843MPLowcountry Aviation Company Brokerage LLC · Walterboro, SCBuilt 2001 · S/N CNS018N8443BDerleth Scott M · Soldotna, AKBuilt 2006 · S/N 0405398N844ACSargent Scottie Joe · West Liberty, KYS/N 0705411N8546ZGriffith Anthony D · Jamestown, TNS/N 76885N855JDRush William B · Newberry, SCBuilt 2007 · S/N 07SC071N855SRHall Richard B · Milford, MABuilt 2005 · S/N SKR0412537N861CAAviation Financial Corp · Torrance, CABuilt 2010 · S/N 050N869ARHaulman Steve R · Pacifica, CABuilt 2012 · S/N 498 SWN 100 ISN86ELRegistered aircraftBuilt 2009 · S/N 0207457N870UNCastille Zachary J · Houston, TXBuilt 2019 · S/N LS9031N8768BRegistration Pending · Glastonbury, CTRegistration pendingBuilt 1997 · S/N MK011N884BHStoneman Stan · Pearland, TXBuilt 2010 · S/N 120122N887EClements Steven D · Boise, IDBuilt 2002 · S/N 07010936N888MMTroubleshooter Network Inc · Centennial, COBuilt 2011 · S/N F-11-03-05N894MHBarnett Tom A · Apple Valley, CABuilt 2021 · S/N DH131N8975FDances With Buzzards Society · Wilmington, DEBuilt 2007 · S/N 06-10-51-550N897WTBarbee Donald · Columbus, OHS/N 02041553N898VBCrawford Drew J · Burnsville, NCBuilt 2007 · S/N 07SC061N8DVKahrs Nicholas · Otis, COBuilt 2013 · S/N 060800011N901BHHenriques Bernard O · Lowell, ARBuilt 2016 · S/N KB07-4-00019N9035PSanders Daniel K · Cuba, NMBuilt 2007 · S/N IPP7-345N9042XKing Ralph W · Minneola, FLBuilt 2004 · S/N 1MK347CN905JSSalzmann Robert E · Fern Park, FLFirst renewal noticeBuilt 2008 · S/N SD912013007-5N906JPLucas Steven · Estacada, ORBuilt 2021 · S/N A370ULSN906KGHarrelson Paul · Wichita Falls, TXBuilt 2021 · S/N A518PEGN906SLGarner L Michele Trustee · Nashville, TNBuilt 2009 · S/N 2009 1202N907SLMoore Joseph · San Luis Obispo, CAS/N 2009 1203N909KCN909kc Aircraft Holding LLC · Costa Mesa, CABuilt 2024 · S/N 1063/USN90GUK5 Aviation LLC · Las Vegas, NVS/N 04-205N911BGBranscomb Brian Kent · El Granada, CABuilt 2009 · S/N G96080176-1N911XLMason Craig · Austin, TXBuilt 2009 · S/N H20055N912AMBruening Michael S · Humboldt, SDS/N PC03079XW3N912HWJudd James H Jr · Marana, AZS/N 10030982N912KAHamstra Bryant · Boerne, TXBuilt 2025 · S/N 026-D-23 EXULN912LCLange Daniel M · Whitewater, WIBuilt 2007 · S/N 047N912LJJohnston Loyd D · Buena Vista, COBuilt 2009 · S/N IPP9-383N912NJEvans Eugene L · El Mirage, CABuilt 2001 · S/N T01082N912PFAnywhere Airplane LLC · Madera, CABuilt 2011 · S/N 68/USN912PKMississippi River Raptor LLC · Lake City, MNBuilt 2005 · S/N 455N912QWhite James T · Gaffney, SCBuilt 2006 · S/N 8168N912RTThomas James R · Pittsboro, NCBuilt 2015 · S/N C9507-0119N912SKJohnson Scott E · Wausau, WIBuilt 2005 · S/N 03051643N912TFZaloski Robert M · Gaylordsville, CTBuilt 2007 · S/N XT-912-0172N912USSchmid Urs · Jupiter, FLBuilt 2007 · S/N 06061752N912VCarlson Carrie M · Lake Wylie, SCBuilt 2006 · S/N C95050116
Back to AD 2012-16-13