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.

N212SRPegasus Flyers LLC · Queen Creek, AZBuilt 2006 · S/N 1871N212TAJensen Paul · Exeter, NEBuilt 2005 · S/N 29-0392N212TJ212tj LLC · Monterey, CABuilt 2004 · S/N 41038N212TSParkside Automotive & Truck Service · Mountain Top, PABuilt 1980 · S/N 21064214N212TWLeaving On Tulsa Time LLC · Tulsa, OKBuilt 2000 · S/N TH-1950N212TXCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11523N212WKRbm Adventures LLC · Jamestown, NYBuilt 1979 · S/N P21000372N212WVKoval John S Trustee · Marysville, OHBuilt 2022 · S/N 8950N21314Merritt Robert · De Kalb, TXBuilt 1999 · S/N 30-0020N2131ZAllen Travis · Newport, MEBuilt 1982 · S/N 18268165N2134UDean Steel Buildings Inc · Fort Myers, FLBuilt 1982 · S/N 21064775N2138CAv Holding Co LLC · Polson, MTBuilt 1986 · S/N 46-8608020N2138SStamm Roy Peter · Woodstock, GABuilt 1975 · S/N 21061099N2138ZPyle Richard B · El Paso, TXBuilt 1998 · S/N 29-0158N213AGCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11548N213ARAdelle Aviation LLC · Sacramento, CABuilt 2013 · S/N 0623N213CAAble 1 Aviation Inc · Las Vegas, NVBuilt 2014 · S/N 4094N213CFSchantz David E Trustee · Raleigh, NCBuilt 2022 · S/N 8557N213CGThomas Leasing LLC · Niota, TNBuilt 2016 · S/N 1409N213CPTitsworth Richard D · Novi, MIBuilt 2008 · S/N 3142N213DRCon-Ag Rentals Inc · Blairsville, GAFirst renewal noticeBuilt 1999 · S/N E-3247N213JPEducators Aviation LLC · Wilmington, DEBuilt 1986 · S/N 4608030N213JWLipidex Corp · Marshfield, MABuilt 2004 · S/N 1089N213KSTenedos LLC · Tacoma, WABuilt 2017 · S/N 1490N213KTCirrus Middle East Inc Trustee · Wilmington, DEBuilt 2026 · S/N 11576N213LBPetro Larry D · Washington, DCBuilt 2004 · S/N 42051N213LMDavis Aircraft LLC · Sarasota, FLBuilt 2023 · S/N 9458N213MRogers Ronald J · Crystal Lake, ILBuilt 1978 · S/N 310R1335N213MLTrue Air Speed LLC · Saint Francisville, LABuilt 2020 · S/N 4886N213MPFly High Aircraft Sales LLC · Ocilla, GABuilt 2025 · S/N 10767N213PG213pg Inc · Chattanooga, TNBuilt 2022 · S/N 8702N213RJCrw Enterprise Holdings LLC · Newark, DEBuilt 2003 · S/N 0737N213SEAircraft Partner N213se Dst · BerlinS/N 2391N213SRDonegan Kevin M · Amissville, VABuilt 2006 · S/N 2100N213TBDonley John Roger · Eagle Lake, FLS/N 1056N213TWPonozzo Donald A · Muskegon, MIBuilt 2023 · S/N 3FX043N213WDHamill Enterprises LLC · Reinholds, PABuilt 2004 · S/N 1121N2140DEaton Darryl S · Santa Barbara, CABuilt 2000 · S/N 30-0044N21434Ad-A-Note LLC · Tarentum, PABuilt 1998 · S/N 29-0159N2143JTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N TH-1855N2143SBaiocchi Ken P · San Jose, CABuilt 1975 · S/N 21061104N2144PVanderhoof Brian L · Purcellville, VABuilt 1998 · S/N 29-0160N21452Moniri Robert · Cumming, GABuilt 1999 · S/N 30-0027N2145SHenry James · Bonita, CABuilt 1975 · S/N 21061106N2145XMitchell Derrick · Winter Park, FLBuilt 1998 · S/N 29-0138N21479Focht Ronald D · Fort Myers, FLBuilt 1999 · S/N 30-0028N2149ZBauer Jeff C · North Falmouth, MABuilt 1980 · S/N 28-7916380N214BBMessina Mark · Wallingford, CTBuilt 2001 · S/N 0085N214BRBaba Daniel · Glastonbury, CTBuilt 2007 · S/N 2318N214CLCx Aviation Inc Trustee · Wilmington, DEBuilt 2012 · S/N 3830
Back to AD 2012-10-13