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.

N912VAVans Aircraft Inc · Aurora, ORBuilt 2018 · S/N 12003N912VZRuiz Michael · Mary Esther, FLS/N 120171N912XEDessart Peter L · Wilmington, DEBuilt 1997 · S/N CAG02471SN913DTWilley Michael S · Saint Paul, MNBuilt 2015 · S/N 0314605N913PHHebson Philip · Southern Pines, NCBuilt 2024 · S/N JA606-12-20N913RHFlorida Autogyro LLC · Edgewater, FLBuilt 2013 · S/N M01051N913WThomas Darryl Lance · Belfield, NDBuilt 2007 · S/N JAESC0104N914AJMitchell Vernon F Jr · Mangum, OKS/N 1009060N914KPrecht Kelly D · Bell City, LABuilt 2009 · S/N IPP9-386N914MSStewart Mark J · Orting, WABuilt 2022 · S/N JA589-06-20N914WHZiegler Aviation LLC · Minneapolis, MNBuilt 2015 · S/N AC-184N9168PMattson Richard A · Saginaw, MNBuilt 2007 · S/N D00912COHK0376N916TFMiller Timothy · Gig Harbor, WABuilt 2022 · S/N 121010N9175RPadgett Joseph P · Trinidad, TXS/N 08031521N918AWWilcox Anthony D · Sterling, VABuilt 2013 · S/N 120673N919MPWilliams John S · New Harmony, UTBuilt 2008 · S/N 7-5781N91GSStabel Gerald · Zeeland, MIBuilt 2022 · S/N SAXLD 115N923ENHand Richard · Corvallis, ORBuilt 2021 · S/N 121115N9252TRudiger Edward J · Staten Island, NYS/N 3104N9296FDetwiler Michael C · Meridian, IDS/N 01000901N9298EWilliams Arthur Jr · Burns, TNBuilt 2000 · S/N T00057N933KFDibble Major A · Nacogdoches, TXBuilt 2018 · S/N 933N933KNKent Clive · Bishop, CABuilt 2022 · S/N E9035N936TXSunda Henry J · Douglass, TXBuilt 2008 · S/N PC0208REP401N938EQLehman Charles A · Santa Rosa Beach, FLBuilt 2022 · S/N 30BN940TAStark Gary · Perris, CABuilt 2014 · S/N 140/USN9419GRegistration Pending · Tavares, FLRegistration pendingBuilt 2007 · S/N 1DK371CN941BAAlbritton Billy T · West Monroe, LABuilt 2008 · S/N 7-5170N941MCAverette James R · Zebulon, NCBuilt 2007 · S/N CAK03771SN9438SPugh David J · Pinconning, MIBuilt 2007 · S/N 12061787N943YDSale Reported · Dover, DESale reportedBuilt 2022 · S/N PT0035BN944CTRick Haney M · Eagle Creek, ORBuilt 2011 · S/N 03-06-05-30N94522Griffith Lewis A · Arlington, TNS/N 912003N94545Pickering Nolan E · Kaysville, UTBuilt 2004 · S/N A019ULSN94557Lkl Aviation LLC · Avinger, TXBuilt 2004 · S/N 000577N9455RDunshee Duane C · Petoskey, MIS/N 1DK417CN945CBMenassian Holdings LLC · Montebello, CABuilt 2023 · S/N 376/USN9471GGriffith Gary N · Castle Rock, COBuilt 2014 · S/N 1002N950TCBraendel Addison · Chicago, ILS/N AC 126N95177Kivell Bret J · Aurora, IABuilt 2008 · S/N T2080103N951GVAb Prop Plane II LLC · Metairie, LABuilt 2017 · S/N 212/USN952GVKachemak Bay Flying Service Inc · Temple, TXBuilt 2017 · S/N 221/USN953AAWings Over Texas Holdings LLC · Denton, TXBuilt 2025 · S/N 425/USN953GVA S Flight Academy LLC · Lantana, FLBuilt 2017 · S/N 222/USN954GVHch Aviation Holdings LLC - Series N954gv · Nacogdoches, TXBuilt 2017 · S/N 224/USN955GVAviation Financial Corp · Torrance, CABuilt 2017 · S/N 225/USN956GVFive Star Marketing Inc · Morrisville, NCBuilt 2017 · S/N 229/USN956RBGalanakis Anthony · Palm Harbor, FLS/N 001N957GVPilot Training Center LLC · Miami, FLBuilt 2017 · S/N 228/USN958GVHch Aviation Holdings LLC - Series N958gv · Nacogdoches, TXBuilt 2017 · S/N 230/US
Back to AD 2012-16-13