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.

N601HDBeaulieu Paul S · Lamar, MOBuilt 1996 · S/N 63077N605AWSaurenman Edward E · Southampton, NYS/N SAW-1001N605VAN605va LLC · Newnan, GABuilt 2023 · S/N 393/USN605VJHueber Richard F · Batavia, OHBuilt 2008 · S/N 605N60CZDougherty Jacob · Belton, TXBuilt 2006 · S/N 185N60DFKing Randall Keith · Woodruff, SCBuilt 2006 · S/N 060N60KKKrusty Kaptin LLC · Frederick, MDBuilt 2020 · S/N 296/USN611BTBreit Joseph Howard · Rapid City, SDBuilt 2022 · S/N 1081 SFNM 912LSAN612CLEsposito Joseph S · Jacksonville, FLBuilt 2009 · S/N 1DK391CN612CMWolfer Jeremy · Boynton Beach, FLBuilt 2007 · S/N 07SC014N612DGGilliland H Dee · Brandon, MSBuilt 2006 · S/N 09051690N6139DHall Timothy F · Pittston, MEBuilt 2000 · S/N SKR0112156N613TKTomark Aero USA LLC · Frisco, TXBuilt 2009 · S/N 0008N61412Lookout Mtn Flight Park Inc · Rising Fawn, GABuilt 2002 · S/N 58BN614JSGrieve David C · Hutchinson, KSBuilt 2007 · S/N 06051671N6166RTejchma Robert R · Norton Shores, MIBuilt 1998 · S/N UA003N616HRKrause Frank · Sarasota, FLBuilt 2016 · S/N 318N61724Eldridge Dennis · Ely, NVBuilt 1996 · S/N 946N61741Morton Mark O · Albuquerque, NMBuilt 2003 · S/N XT-912-014N618FRTindle James E · Clewiston, FLS/N 20076181118MDFN618LGSkyship Services Inc · Windermere, FLBuilt 2000 · S/N 018N61998Pettus Gary A · Fort Mill, SCS/N 1MK335CN61TKKane Thomas E · Mcalpine, FLBuilt 2014 · S/N JA334-12-13N620LGLta Galactic Inc · Akron, OHBuilt 2002 · S/N 020N623AAWings Over Texas Holdings LLC · Denton, TXBuilt 2025 · S/N 430/USN624AAWings Over Texas Holdings LLC · Denton, TXBuilt 2026 · S/N 432/USN627LSYonkin John Thomas · Dushore, PABuilt 2009 · S/N A007ULSN627MPPorter Mike W · Lake Elsinore, CABuilt 2013 · S/N 1091229N628FSScheidegger Frederick W · Hudson Falls, NYBuilt 2005 · S/N KR0402441N629CBBartlett Charles F Jr · Stockbridge, GAS/N 000702N629KFRegistered aircraftBuilt 2001 · S/N S9808 0160N630CBAb Prop Plane I LLC · Metairie, LABuilt 2022 · S/N 372/USN631DAMongare Job · Athens, TXBuilt 1997 · S/N 10301N631PSCauble Tyler D · Valley Center, KSBuilt 2007 · S/N 09051689N636SCBleggi Zachary E · Salem, UTBuilt 2007 · S/N 07SC015N638AAWings Over Texas Holdings LLC · Denton, TXBuilt 2025 · S/N 431/USN63TSSanches Anthony W · Montgomery, TXBuilt 2014 · S/N JA279-10-12N640AAWings Over Texas Holdings LLC · Denton, TXBuilt 2026 · S/N 433/USN642AAWings Over Texas Holdings LLC · Denton, TXBuilt 2025 · S/N 429/USN647TSCrooks James R · Carpinteria, CAS/N XT-912-008N65086Atkins Thomas · Brooklyn, NYBuilt 1994 · S/N 025N654MMLehman Vernon L · Mannford, OKBuilt 1995 · S/N 91008N654MTTurner Mike W · Lucedale, MSBuilt 2023 · S/N 7-5025N655PMOrdway Dwight H · Patten, MES/N SKR0111134N6562GFields Anthony D · Ona, WVBuilt 2007 · S/N RR0205186N665EZChaouli Consulting Group Inc · Moriarty, NMBuilt 2018 · S/N 897 SW 100 ISN666SPMejia Agustin - Guardian · Key Biscayne, FLBuilt 2001 · S/N 093N667ZMascot Two LLC · Boise, IDBuilt 2012 · S/N 499 SWN 100 ISN66KGCrosswind Aviation Of Oklahoma LLC · Stillwater, OKBuilt 2009 · S/N 06/USN671CAMid-Atlantic Air Ventures Inc · Richmond, VABuilt 2006 · S/N 186
Back to AD 2012-16-13