AD 75-09-05

Registered aircraft · 371

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

N200BJWright Thomas L · Clyde, OHBuilt 1975 · S/N 33701684N211EWJtb 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-0124N222LJDodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N 33701764N2238XStyron 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-0190N2294XCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1965 · S/N 337-0194N2299XSturgeon Keith A · Saginaw, TXS/N 337-0199N22CMDavis Frederich K · Dunbar, PABuilt 1965 · S/N 337-0159N22MDHolland Bryan K · Sterling, AKBuilt 1966 · S/N 337-0590N22PNLingle Gordon D · Gun Barrel City, TXBuilt 1966 · S/N 337-0538N2332SLouisiana Military Museum · Abbeville, LAS/N 337-0632N2344SAnderas Per R · Green Bay, WIBuilt 1967 · S/N 337-0644N2345SSummers Jeffrey L · Pekin, INBuilt 1967 · S/N 337-0645N2362SMclaren Institute Of Transporation Technologies · Goode, VABuilt 1967 · S/N 337-0662N2366SDaughtrey Kevin E · Arcadia, FLS/N 337-0666N2382SMielczarek Joe I · Santa Paula, CABuilt 1967 · S/N 337-0682N2397SState Of Wisconsin · Madison, WIBuilt 1967 · S/N 337-0697N2413SQualitair LLC Trustee · MichelstadtBuilt 1967 · S/N 337-0713N2417SPiasecki Aircraft Corporation · Coatesville, PABuilt 1967 · S/N 337-0717N243MBSwanson Timothy J · Bannister, MIBuilt 1967 · S/N 337-0813N246BTGentile Keith · Riverton, UTBuilt 1967 · S/N 337-0769N2474SEllison William K · Tipton, INBuilt 1967 · S/N 337-0774N2486SDarvek LLC · Las Vegas, NVBuilt 1967 · S/N 337-0786N2491SGeorge Ladelle L · Ashley, NDBuilt 1967 · S/N 337-0791N24DCCraig Joshua · Bonaire, GABuilt 1975 · S/N 33701640
Back to AD 75-09-05