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.

N2083SDave Schmauderer · Woodland, CAS/N 21061049N20849Tradewind Ventures LLC · Evans, GABuilt 1999 · S/N 30-0017N2084SSecondhand Flying LLC · Ogden, UTBuilt 1975 · S/N 21061050N2085SRichards John · Casa Grande, AZBuilt 1975 · S/N 21061051N208PGrateful Center Transportation LLC · Lutz, FLBuilt 1991 · S/N TH-1626N2092SMidwest Airmotive Inc · Mount Sterling, KYBuilt 1975 · S/N 21061058N209DCDelaware Corp · Topping, VABuilt 1979 · S/N 414A0229N209DWWhite Columbia Inc Trustee · Wilmington, DEBuilt 2005 · S/N 41504N209HWWep Ent LLC · Graford, TXBuilt 2004 · S/N 29-0330N209JAHowen Kyle Verne · San Luis Obispo, CABuilt 2016 · S/N 4309N209KSSchneider Kerry · Alpine, WYS/N P21000560N209MEUnbound Aviation LLC · Kalispell, MTBuilt 2021 · S/N 2366N20CAState Of California Department Of Transportation · Sacramento, CABuilt 2019 · S/N 4844N20DPErvin Eric · La Follette, TNBuilt 1988 · S/N 4608140N20JNGana Trucking & Excavating Inc · Martell, NES/N 340A0050N20KKChimney Pond Aviation LLC · New York, NYBuilt 2013 · S/N 0676N20LN303cj LLC #1 · Lexington, KYBuilt 2008 · S/N 3195N20MCOpie Aviation Services LLC · Nashville, NCBuilt 1979 · S/N 25-0067N20MLRegistration Pending · Yorba Linda, CARegistration pendingBuilt 2019 · S/N 1945N20PYSvinth James B Trustee · Coto De Caza, CABuilt 2021 · S/N 2318N20PZBend Aviation Specialties LLC · Portland, ORBuilt 2014 · S/N 0775N210AAMeckley Sean H · Seattle, WABuilt 1982 · S/N 21064690N210ABRudy Schmitt · Brookshire, TXS/N 21059209N210ALE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 2013 · S/N 0549N210ARVjc Air LLC · Katy, TXBuilt 1975 · S/N 21061077N210AXKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1979 · S/N 21063033N210AZAerialtraders LLC · Estero, FLBuilt 1972 · S/N 21059678N210BGTurner Kenneth W · Arlington, WABuilt 1978 · S/N P21000025N210BHGlenn Wade Corp · Tucson, AZBuilt 1975 · S/N 21060954N210BPBbsc LLC · Wilmington, DEBuilt 1981 · S/N 21064300N210CJettech Holdings LLC · Broomfield, COBuilt 1979 · S/N P21000218N210CAPennmark Air LLC · Plymouth Meeting, PABuilt 2023 · S/N 9466N210CBCampbell Terry G Trustee · San Francisco, CABuilt 2025 · S/N 10411N210CCMuller Rodolfo · Kerrville, TXBuilt 1978 · S/N 21063008N210CEMaas Aviation LLC · Pewaukee, WIBuilt 1980 · S/N P21000563N210CFQuest Aviation Inc · Lake City, FLBuilt 1978 · S/N 21063124N210CHOne Up LLC · Stuttgart, ARBuilt 1974 · S/N 21060142N210CKFann Robert P · Birmingham, ALBuilt 2003 · S/N L2K-148N210CPToeppen Chris P · Atherton, CABuilt 1979 · S/N P21000230N210CWBeach Partnership LLC · Myrtle Beach, SCBuilt 1979 · S/N 21063595N210CX210 Equipment LLC · Lexington, SCBuilt 1972 · S/N 210-59719N210DDDwoskin David F Trustee · San Pedro, CABuilt 1976 · S/N 21061464N210DLDaneco LLC · Houma, LABuilt 1978 · S/N P21000114N210DRRaid Air LLC · Grand Rapids, MNBuilt 1978 · S/N 21063011N210DSSevel Garry S · Fresno, CABuilt 1981 · S/N 21064275N210EBBuell Jack A · St Maries, IDBuilt 1978 · S/N 21062568N210EFDespain Aviation LLC · Pendleton, ORBuilt 1979 · S/N P21000391N210FMAero M Inc · Key West, FLBuilt 1979 · S/N P21000259N210FVAvoyelles Rental Corp · Bunkie, LABuilt 1980 · S/N P21000572N210GUTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1978 · S/N P21000067
Back to AD 2012-10-13