OpenAirDocs.org
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.

N2002PGregory Edward · Council Bluffs, IABuilt 1979 · S/N 335-0022N2007Bondair LLC · Seattle, WABuilt 2023 · S/N 9384N20098Registered aircraftBuilt 1999 · S/N 30-0029N200ARHelijet Holdings LLC · Wellington, FLBuilt 2004 · S/N 1122N200DRRowe Daniel · Alexandria, VABuilt 2019 · S/N 4860N200GCDancy Abram P · Shrewsbury, MABuilt 1978 · S/N 340A0503N200HCIncredible Travels LLC · Celina, OHBuilt 2008 · S/N 3286N200LBBresciani Martin · Guaynabo, PRBuilt 2002 · S/N 0209N200MCN200mc Inc Trustee · Cheyenne, WYBuilt 1973 · S/N 414-0424N200RCRc Aviation LLC · Omaha, NEBuilt 1975 · S/N 21061073N200RTRiley Nolan C · Lubbock, TXS/N TK-101N200UAUrrea Hugo Edmundo Rincon · Houston, TXBuilt 1980 · S/N 21063921N200VPDrp Aviation LLC · Southlake, TXBuilt 2000 · S/N 29-0231N200WRVaughan Jason B · Sublette, KSBuilt 1978 · S/N 21062478N2011SHeath Stephen · Alpine, TNBuilt 1975 · S/N 21060979N2012S9791m LLC · Tacoma, WAS/N 21060980N2018LKrielow Law Firm LLC · Thibodaux, LABuilt 1978 · S/N TK-80N2019SMoore Bobby E · Perry, OKBuilt 1975 · S/N 21060987N201AHPrje Technology Services LLC · Kalispell, MTBuilt 2013 · S/N 0498N201BLBadiozamani Abdolhamid · San Diego, CABuilt 2005 · S/N L2K 177N201DRegistered aircraftS/N TK-24N201FDCavu 22 LLC · Stuart, FLBuilt 2025 · S/N 10391N2028SScherler Burl M · Sheridan Lake, COBuilt 1975 · S/N 21060996N202BHarper Aviation LLC · Arlington, TXBuilt 2025 · S/N 10730N202CMCambridge LLC · New Cumberland, PABuilt 2005 · S/N 1684N202FDPro Ag Aviation LLC · Luverne, MNBuilt 2025 · S/N 10394N202JTHour Time Machine LLC · Bloomington, INBuilt 2002 · S/N 0230N202PSc Infinities LLC · Dover, DEBuilt 1998 · S/N TH-1875N202SRCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11394N202SWMar Jar LLC · Gilmer, TXFirst renewal noticeBuilt 1980 · S/N 414A0515N2031ZJames Jeb S Dr · Bay City, TXBuilt 1978 · S/N TJ-165N2034JMd Aero LLC · Somerton, AZBuilt 1978 · S/N T18803339TN2037ACrosswind Enterprises LLC · Box Elder, SDBuilt 1979 · S/N EA-3N2037SRubyco Inc Trustee · Wilmington, DEBuilt 1975 · S/N 21061005N2038SHatch Family Limited Partnership · Winslow, AZBuilt 1975 · S/N 21061006N203FDBiricik Cemhan · Boca Raton, FLBuilt 2025 · S/N 10395N203JLJfra LLC · Miami, FLBuilt 1981 · S/N 414A0670N203RFRapid Flyers LLC · Rapid City, SDBuilt 2003 · S/N 0453N203VMyers Daniel Kenneth · Madison, MSBuilt 2007 · S/N 22N2041CFly Frannie LLC · Scottsdale, AZBuilt 2023 · S/N 9047N2043SAppel Daniel E · Redfield, SDBuilt 1975 · S/N 21061010N2046SYankee Clipper LLC · Dayton, OHFirst renewal noticeS/N 21061013N2046YBrainerd William F III · Sapello, NMBuilt 1978 · S/N E-1395N204BRRand Joseph · Osprey, FLBuilt 2002 · S/N 0248N204CDChmielewski David · Sevierville, TNBuilt 2026 · S/N 11182N204GXAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 29-0373N204PT A Infinities LLC · Dover, DEBuilt 1991 · S/N E-2601N204TSAs The Crow Flies Aerial Services LLC · Irving, TXBuilt 1977 · S/N U20604052N2050SDavis Bryan C · Winfield, KSBuilt 1975 · S/N 21061017N2055QJones Jeff A · Lewiston, IDBuilt 1975 · S/N U20602965
Back to AD 2012-10-13