OpenAirDocs.org
AD 52-25-02

Registered aircraft · 874

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:52-25-02')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:52-25-02')
  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.

N1210HThiel Scott D · Edgewood, WABuilt 1946 · S/N 3887N121VVBowers Airplanes LLC · Chesterfield, VABuilt 1946 · S/N 3440N123YPLeochner Jason F · Decatur, TXBuilt 1947 · S/N 4503N127GBaine Larry A · Marne, MIBuilt 1963 · S/N 4795N13PQAllen Ron · Oceanside, CABuilt 1946 · S/N 3544N142Rains Cecil R · Wichita, KSBuilt 1940 · S/N 12N153JDMorgan Thomas R · San Antonio, TXBuilt 1946 · S/N 284N15JLTravland Lewis H · Alpine, TXS/N 2410N1611Hibler Kenith R · Newcastle, OKBuilt 1946 · S/N 1537N168PMcmanus Brian K · Smithville, TXBuilt 1946 · S/N 905N179GAnderson John P · Knoxville, TNBuilt 1946 · S/N 1802N17JDSpecht Leo M · Towner, COS/N 4354N194HSFuller Randy M · Mooresville, NCS/N 1517N1NYTech Mobile LLC · New Windsor, MDBuilt 1946 · S/N 1674N2005HLaslo Lawson P · Oklahoma City, OKBuilt 1946 · S/N 2628N2007HElder Robert C · Prosser, WABuilt 1946 · S/N 2630N2021HGregory Vernon L · Swansea, SCBuilt 1946 · S/N 2644N2022HGartke Michael L · Waterman, ILBuilt 1946 · S/N 2645N2024HVarzavand Shahram · Cedar Falls, IABuilt 1946 · S/N 2647N2034HWustrack Jeffrey F · Wichita, KSS/N 2657N2038HOgren Michael W · Spring Hill, FLBuilt 1946 · S/N 2661N2050HCopaair Maintenance Services Inc · Indiantown, FLBuilt 1946 · S/N 2673N2064HMcbride Devin · Forney, TXS/N 2687N2065HAnderson Nancy L · Chehalis, WAS/N 2688N2078H84 Aviation Llp · Lebanon, OHBuilt 1946 · S/N 2701N2081HGutierrez Ryan Y · Pacoima, CABuilt 1946 · S/N 2704N2083HHatcher Joe W · Ripon, WIBuilt 1946 · S/N 2706N2095HStovall Spencer R · Iuka, MSBuilt 1946 · S/N 2718N2102HHarvell Randall W · Manteno, ILS/N 2725N2122HSmith Gaynor J · Clay Center, NEBuilt 1946 · S/N 2745N2128HVecchio Alfred James · Emerado, NDBuilt 1946 · S/N 2751N2129HMathison John M · Fernley, NVBuilt 1946 · S/N 2752N2149HGovin James M · Ball Ground, GABuilt 1946 · S/N 2772N214RPBeebe Gerald W Jr · Lathrop, MOBuilt 1947 · S/N 4793N2166HCrone Janice C · Frederick, MDBuilt 1946 · S/N 2789N2169HPecoraro Carmine F · Kirkland, WABuilt 1946 · S/N 2792N2176HLandry Robert J · Winston Salem, NCBuilt 1946 · S/N 2799N2180HGraf Edwin X · Washington Island, WIBuilt 1946 · S/N 2803N2191HCoulson Mark Douglas · Zanesville, OHBuilt 1946 · S/N 2814N2203HKhanna Varun · Kent, WABuilt 1946 · S/N 2826N2212HDenault Christopher A · Union Hill, ILBuilt 1946 · S/N 2835N2213HValentine Rolland N · Atlanta, MIBuilt 1946 · S/N 2836N2237HEason James D · Leawood, KSBuilt 1946 · S/N 2860N2239HGreen Michael B · Kent, WABuilt 1946 · S/N 2862N2240HRoberts Shane · Las Cruces, NMBuilt 1946 · S/N 2863N2247HGerdes Brian K · Los Alamitos, CABuilt 1946 · S/N 2870N2248HPayne Emily R · Lake Mills, IABuilt 1946 · S/N 2871N2253HBlakely Charles G · Ellijay, GABuilt 1946 · S/N 2878N2256HKoberstein Tracy T · Pilot Rock, ORS/N 2881N2270HGehrman Holdings LLC · De Pere, WIBuilt 1946 · S/N 2895
Back to AD 52-25-02