AD 75-01-07

Registered aircraft · 2,118

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-01-07')
    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-01-07')
  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.

N3211LPrevost Bryan · Lambert, MTBuilt 1976 · S/N D-9914N321BWAero Marine Inc · Westland, MIBuilt 1966 · S/N D-8343N322HSReed Systems Ltd · Ellenville, NYBuilt 1974 · S/N D-9709N323UShaneyfelt Samuel J · Shady Shores, TXBuilt 1966 · S/N D-8029N324DBush David M · Englewood, COBuilt 1965 · S/N D-8016N325MGLock N Climb LLC · Independence, KSBuilt 1977 · S/N D-9990N32631Grewell Dean R · Waukee, IABuilt 1979 · S/N D-10301N326SCuruchet Shay · Kaycee, WYBuilt 1969 · S/N D-9067N327DBonanza Flyers LLC · Aurora, COBuilt 1965 · S/N D-7801N328BNothing Wasted LLC · Bunker Hill, INBuilt 1966 · S/N D-8307N328HRShuster David · Fredericksburg, VABuilt 1979 · S/N D-10269N328SFast Flight Inc · Springdale, ARBuilt 1969 · S/N D-9068N329RTRegistered aircraftBuilt 1972 · S/N D-9343N329XLima 2 Aviation Of Mississippi LLC · Bogue Chitto, MSBuilt 1964 · S/N D-7509N32BHBechtold Brahm Hellman · Parker, COBuilt 1977 · S/N D-10046N32DERatcliff Daniel Trustee · Austin, TXBuilt 1977 · S/N D-9965N32PPDenison Aviation Inc · Atlantic, IABuilt 1964 · S/N D-7702N333JPSpeece Ryan J · Vero Beach, FLBuilt 1967 · S/N D-8539N333LJJarrell Christopher · Lincolnton, NCBuilt 1969 · S/N D-8969N333RJAddco Aviation Services Inc · Newcastle, OKBuilt 1978 · S/N D10188N334Jeffrey Mark · Clayton, MIBuilt 1967 · S/N D-8467N334CHLittle River Aviation LLC · Tifton, GABuilt 1977 · S/N D9962N3358AWagner Richard L · Willis, TXBuilt 1969 · S/N D-9062N335JAAstrologo Joseph A Jr · Tullahoma, TNBuilt 1964 · S/N D-7576N335NMarple Scott D · Indianapolis, INBuilt 1964 · S/N D-7752N335TCSchnell Daniel · Sisters, ORBuilt 1966 · S/N D-8274N335VHolden Donald T · Cherokee, IABuilt 1980 · S/N D-10338N33FSBvd Inc · Yates Center, KSBuilt 1974 · S/N D-9658N33FXDougfly Inc · Malibu, CAS/N D-10105N33HTGroove LLC · Afton, VABuilt 1965 · S/N D-7885N33JLJ L Flyers LLC · Orinda, CABuilt 1968 · S/N D-8764N33VBVb313 LLC · Fort Myers, FLBuilt 1976 · S/N D-9899N33VHRegistered aircraftBuilt 1975 · S/N D-9803N33VSRare Eagle Aviation LLC · Westcliffe, COBuilt 1977 · S/N D-10071N340DN340dholding LLC · Allen, TXBuilt 1967 · S/N D-8642N341VTBelmont Leasing LLC · Gig Harbor, WABuilt 1964 · S/N D-7589N342UWelch Robert T · Alamogordo, NMBuilt 1971 · S/N D-9251N346BGWebstrong Aviation LLC · Conway, ARBuilt 1973 · S/N D9494N346S200 Knot LLC · Amarillo, TXBuilt 1969 · S/N D-9092N348SKoritz Iowa Properties LLC · Key Colony Beach, FLBuilt 1970 · S/N D-9125N350HAims Community College · Greeley, COS/N D-8188N350NEMaresco International Corp · Alpha, NJBuilt 1980 · S/N D-10351N350YRSilverman Kenneth · Pelham, NHBuilt 1982 · S/N D-10383N3511VCypress Creek Shooting Lodge LLC · Greenbrier, ARBuilt 1980 · S/N D-10353N351ATRegistered aircraftBuilt 1967 · S/N D-8507N351RSSmith Herschel W III Md · Roswell, GABuilt 1966 · S/N D-8299N351VBWudtke Dale A Trustee · Palos Park, ILBuilt 1970 · S/N D-9207N3526ARoeder Miles · Houston, TXBuilt 1969 · S/N D-9075N352RHHackler Russell W Jr · Livermore, CABuilt 1964 · S/N D-7562N353RSecond Time Around Lt LLC · Corona, CAS/N D-10209
Back to AD 75-01-07