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.

N66PCHeinzle Hamblin LLC · Eagar, AZBuilt 2001 · S/N LIV 454N66PE811wm LLC · Watertown, CTBuilt 2004 · S/N 1220N66RAGasu LLC · Henderson, NVBuilt 1981 · S/N 340A1231N66SBBay West Aviation LLC · San Francisco, CABuilt 2024 · S/N 10033N66SFRed Rock Flying School LLC · Mesa, AZBuilt 1986 · S/N 46-8608042N66TEFly4fun LLC · El Segundo, CABuilt 1978 · S/N P21000154N66TMBarronena LLC · San Antonio, TXBuilt 2018 · S/N 1735N66VGVg Management LLC · Orinda, CABuilt 2022 · S/N 8555N66VMPg Air LLC · Bellbrook, OHBuilt 2005 · S/N 1556N66WSDighans Murray · Peerless, MTBuilt 1979 · S/N P210-00363N6700PAbraham Curtis · Byron, WYBuilt 1978 · S/N P21000200N6709QClear Blue Marketing Inc · Reno, NVBuilt 1983 · S/N EA-368N670CAValiair Lc Trustee · Casper, WYBuilt 2025 · S/N 10920N670CMRedx LLC · North Palm Beach, FLBuilt 2023 · S/N 9425N670DSSongbird Leasing LLC · Nashville, TNBuilt 2019 · S/N 4856N670PCw Veach Logistics LLC · Allerton, IAS/N 1166N670PNAir Powers LLC · Warrensburg, MOBuilt 2020 · S/N 2087N6715RRose Mary R · Portland, ORBuilt 1966 · S/N T210-0115N671BBe-A36 Inc Owner Trustee · Wilmington, DEBuilt 2001 · S/N E-3409N671JBAerostone Holdings LLC · San Saba, TXBuilt 2022 · S/N 8818N671JLJgl Aviation LLC · Boca Raton, FLBuilt 2019 · S/N 4836N671MVJtmtrl LLC · East Haven, CTBuilt 2012 · S/N 0343N671PAMorray Fl LLC · Port Charlotte, FLBuilt 2020 · S/N 2097N671SMRegistered aircraftBuilt 2005 · S/N 41066N671TSpartin Investments LLC · Gallup, NMS/N 990010-MN671TCBraunstein Robert S · Seattle, WABuilt 2001 · S/N EA-671N67224Vx Inc · Burbank, CABuilt 1983 · S/N EA-370N6722BJca Aviation LLC · Safford, AZS/N 21062826N6726SSchaney Michael W · Brookville, OHBuilt 1983 · S/N TH-1390N6728FPeters Bruce L · Wichita, KSBuilt 1983 · S/N EA-379N6728RRegency Horizons Group LLC · Middletown, DEBuilt 1983 · S/N EA-380N6728ZMccrorie LLC · Helena, MTBuilt 1980 · S/N EA-57N672CDRegistered aircraftBuilt 2004 · S/N 1207N672HBValiair Ltd Co Trustee · Casper, WYBuilt 1977 · S/N 340A0324N6731ZJerry Slough Aviation LLC · Bakersfield, CAFirst renewal noticeBuilt 1980 · S/N TJ-255N6733MWilson Lawrence J · West Sacramento, CABuilt 1979 · S/N EA-37N6734UR E Bentz Inc · Monroe, LAS/N TK-117N6736TBrakke Thomas · Clear Lake, IABuilt 1981 · S/N EA-242N6737VRiverview Ranches · Chowchilla, CAS/N EA-63N6739CPearce William · Grants Pass, ORBuilt 1980 · S/N TJ-262N673CDR58 Aviate LLC · Granbury, TXBuilt 2006 · S/N 1771N673DKBh Aero LLC · Hanover, MNBuilt 1979 · S/N 21063479N673RVMev Aviation LLC · Fort Lauderdale, FLBuilt 2026 · S/N 11471N673SRHarrison Terry W · Soldotna, AKBuilt 2007 · S/N 2843N673TBalchunas Anthony B · Robinson, TXBuilt 1967 · S/N D-8470N67414Staley Clifford D · Delray Beach, FLBuilt 1980 · S/N E-1661N6741MCooper Aviation LLC · Georgetown, SCBuilt 1980 · S/N TK-122N6745YSeamech International Inc · Houston, TXBuilt 1984 · S/N EA-401N6746RSchwartz Daniel T · Meeker, COBuilt 1966 · S/N T210-0146N6748CSan Andres Farms · Raymondville, TXBuilt 1980 · S/N EA-76
Back to AD 2012-10-13