OpenAirDocs.org
AD 2012-01-07

Registered aircraft · 248

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-01-07')
    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-01-07')
  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.

N596WTAerial Effects Inc · Sarasota, FLBuilt 2021 · S/N 24213014N599TSr22 LLC · Cedar Rapids, IABuilt 2022 · S/N F-21-09-03N5BDDage Bruce E · Oro Valley, AZBuilt 2004 · S/N 11-091N601JTThompson Jim · Dallas, TXBuilt 2010 · S/N AC145N604TAGoldfine Eric I · Mahopac, NYBuilt 2013 · S/N 081N60TMMtmc LLC · Wilmington, DEBuilt 2025 · S/N 12-060N611KBPrichett Michael G · Eureka, MTBuilt 2008 · S/N 1MK364CN614WBRobinson Stephen C · Garrison, NDBuilt 2015 · S/N JA422-11-14N615BSArnett Randall Curtis · Anchorage, AKBuilt 2015 · S/N 105N617FRTindle James E · Clewiston, FLS/N 2000 617 1118 MDFN619DBreslink LLC · San Diego, CABuilt 2020 · S/N 11N622RTPar Glider Aero LLC · Las Vegas, NVBuilt 2013 · S/N 022N629RTeam Negrich LLC · Osteen, FLBuilt 2008 · S/N 1DK409CN630PCBradburn James I Trustee · Scottsdale, AZBuilt 2022 · S/N 12-046N6379GScully William J · Gardnerville, NVBuilt 2019 · S/N V00403N639DAHarvey Toby Freeman · Alvin, TXBuilt 2007 · S/N D 07 G 44N653CMV-Speed Aviation LLC · Kimberly, IDBuilt 2020 · S/N 6 319 336ZN655CCTimberg Charles D · Spring Park, MNBuilt 2016 · S/N 050N657GBailey Matthew T · Cornelius, ORBuilt 2014 · S/N 1003N65PCBaby Bird Aviation LLC · Sarasota, FLBuilt 2019 · S/N 0038N669DHHertz David · Vermillion, SDBuilt 2016 · S/N 1MK463CN669KKGreen Byron · Lindale, TXBuilt 2010 · S/N JA173-09-08N676DDabbs Robert D · Taylor, TXBuilt 2008 · S/N 16-08-4734N68CJSpratt John E · Minden, NVBuilt 2016 · S/N 03140007N691TAYukon Aviation LLC · Colfax, WIBuilt 2015 · S/N 091N694TDMagni Rotorcraft Inc · Wilmington, DEBuilt 2022 · S/N 24223554N699DEEvans David E · Las Vegas, NVS/N 1DK401CN701TKKoehler Thomas H · Conifer, COBuilt 2008 · S/N 7-5800N714ATAnderson Todd W · Bondurant, IABuilt 2020 · S/N 25457N714KBEmbry-Riddle Aeronautical University · Daytona Beach, FLS/N 36547N724KAFarmland Company Management Inc · Spokane, WABuilt 2012 · S/N KA12254243N725PWLockwood Albert G · Eden, IDBuilt 2006 · S/N 0306430N72PRReimer Lynn C · Sioux Falls, SDBuilt 2018 · S/N 271N732MRReid Michael · Anchorage, AKBuilt 2019 · S/N 12-024N737RHSky King Soaring LLC · Payson, AZBuilt 2009 · S/N 36.847N73HMichaels George A · Shorewood, ILBuilt 2018 · S/N SP0206-003N745TALander David W · Gilroy, CABuilt 2015 · S/N 045N747RDHollingworth Paul A · Santa Rosa, CABuilt 2015 · S/N 16148744N75610Girard Louis W · Schulenburg, TXBuilt 2002 · S/N A2002ULSN757TFPiet Hein 1628 LLC · Middletown, DEBuilt 2022 · S/N VL-3-471N769PWWilson Jd · Resaca, GABuilt 2022 · S/N 04216531014N774HFAir Bender LLC · Olympia, WABuilt 2017 · S/N 1DK459CN782PTKeenan Willard B · Ottawa, ILBuilt 2018 · S/N 24181284N785DDWilliams Suneil S · Bellingham, WABuilt 2012 · S/N 16116844N801DFJgm Aviation LLC · Spring, TXBuilt 2010 · S/N 1MK469CN804TAWoodward-Duncan Christine · Indianapolis, INBuilt 2015 · S/N 104N806LCColburn Richard S · Fort Mohave, AZBuilt 2017 · S/N M0261450HK0006N80DSNarrow Arrow LLC · Travelers Rest, SCBuilt 2017 · S/N 12-010N819JDJgm Aviation LLC · The Woodlands, TXBuilt 2014 · S/N 1LK538CN819JFFlewitt Alan J · Burleson, TXBuilt 2020 · S/N 24202814
Back to AD 2012-01-07