OpenAirDocs.org
AD 70-15-02

Registered aircraft · 297

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:70-15-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:70-15-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.

N102BMeyjes Gijsbert Posthumus · Cadillac, MIS/N 337-0024N108CCFlaugher Jonathan S · Poquoson, VABuilt 1965 · S/N 3370202N110SMPenhall Michael Joseph · Lake Forest, CABuilt 1964 · S/N 337-0023N111ATSkymaster Stc LLC · Mena, ARBuilt 1969 · S/N 337-1125N137MCPoland Gilbert Guardian · Dothan, ALBuilt 1965 · S/N 337-0127N13EFMcgough Julie Eileen · Red Oak, TXBuilt 1967 · S/N 337-0794N1414CSorby Steven R · Lyman, WABuilt 1966 · S/N 337-0419N143JBKing John · Torrance, CABuilt 1965 · S/N 337-0102N1708ZVr Jet LLC · Goshen, INBuilt 1963 · S/N 336-0008N1725ZDavid B Curliss · Beavercreek, OHBuilt 1963 · S/N 336-0025N1730ZLoftis Kenneth L · Phoenix, AZBuilt 1963 · S/N 336-0030N1746ZThompson Nathan G · San Antonio, TXS/N 336-0046N1768ZMoskowitz Craig B · Sheffield, MABuilt 1963 · S/N 336-0068N1773ZMcclay David H · Lagrande, ORBuilt 1963 · S/N 336-0073N1779ZLewis Lionel · Tacoma, WABuilt 1963 · S/N 336-0079N1797ZReal Fly Air Service LLC · Jackson, WYBuilt 1963 · S/N 336-0097N1799ZWanderlove Alaska LLC · Anchorage, AKBuilt 1963 · S/N 336-0099N17TBarney Julius C · Lutz, FLBuilt 1968 · S/N 337-0990N1925JBuzco Aviation LLC · Thomaston, GABuilt 1966 · S/N 337-0431N19PLively Gregory · Corinth, TXBuilt 1969 · S/N 337-1091N1HUCaster-Way LLC · Sebring, FLBuilt 1968 · S/N 337-1008N211EWJtb Logistics LLC · Byars, OKBuilt 1966 · S/N 337-0443N2125XMathews Wade · Wichita Falls, TXBuilt 1965 · S/N 337-0025N212PMEllisor Don · Grapeland, TXBuilt 1966 · S/N 337-0527N2131XBrown Jerry D · Rockport, TXS/N 337-0031N2138XSpencer Douglas J · Greenwood, CABuilt 1965 · S/N 337-0038N2139XAerometrix LLC · Lino Lakes, MNBuilt 1965 · S/N 337-0039N2168XOrtiz Stewart Flynn · San Diego, CABuilt 1965 · S/N 337-0068N2186XAshiku Phillip · Ukiah, CABuilt 1965 · S/N 337-0086N2192XGoldsmith Alejandro J · Houston, TXBuilt 1965 · S/N 337-0092N2200XPowell George · Locust Grove, GABuilt 1965 · S/N 337-0100N2216XSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1965 · S/N 337-0116N2222XOrtiz Stewart Flynn · San Diego, CAS/N 337-0122N2224XRegistered aircraftBuilt 1965 · S/N 337-0124N222WKSchellhorn Friedrick · Harxheim/MainzS/N 337-0696N2238XStyron Mark A · Pasadena, TXS/N 337-0138N2240XTri-Rotor Spray & Chemical · Ulysses, KSBuilt 1965 · S/N 337-0140N2243XSmith Debra A · Louisville, KYS/N 337-0143N2244XPlane Life LLC · Wilmington, DEBuilt 1965 · S/N 337-0144N2255XProp & Jet Air Museum Inc · Romoland, CAS/N 337-0155N2256XPoole Douglas G · California, MDBuilt 1965 · S/N 337-0156N2262XStampfler Richard D · Groveland, MABuilt 1965 · S/N 337-0162N2266XBarney Julius C · Lutz, FLBuilt 1965 · S/N 337-0166N2267XRound Engine Aero · Nashville, MIBuilt 1965 · S/N 337-0167N2271XSantaska Inc · Palmer, AKBuilt 1965 · S/N 337-0171N2273XAll Florida Recovery Corp · Palm Coast, FLS/N 337-0173N2274XDutko Adam M · Elyria, OHBuilt 1965 · S/N 337-0174N2279XSander Farms Inc · Wilmington, DEBuilt 1965 · S/N 337-0179N2284XWilson Gregory S · Cairo, MOBuilt 1965 · S/N 337-0184N2290XMatthews Roy E · Sparta, MIBuilt 1965 · S/N 337-0190
Back to AD 70-15-02