AD 75-07-02

Registered aircraft · 2,162

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-07-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:75-07-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.

N1187CNc Aviator LLC · Fuquay Varina, NCBuilt 1977 · S/N 17702683N11907Housatonic Flying Club Inc · Danbury, CTBuilt 1975 · S/N 17702380N1191CZerfas Gary B · Rockwall, TXBuilt 1977 · S/N 17702684N11937Rdt Aviation LLC · Trumbull, CTS/N 17702381N11950Plenkers Russell A · Molino, FLBuilt 1975 · S/N 17702382N11968Good Guys Finish First Inc · Colorado Springs, COS/N 17702383N1203CMirzaei-Nejad Hamid · Lake Stevens, WAS/N 17702685N1205CNorthern Aire Flying Club Ltd · Black Creek, WIBuilt 1977 · S/N 17702686N12095Ciddio Mark S · Sebastopol, CABuilt 1975 · S/N 17702385N1217MRawashdeh Osamah A · Rochester Hills, MIBuilt 1973 · S/N 177RG0400N121ECN121ecfllyers LLC · South Jordan, UTBuilt 1967 · S/N 17700036N1223MRussell Brian K · Phoenix, AZBuilt 1974 · S/N 177RG0504N122WRRangers Flying Club Inc · Eden Prairie, MNBuilt 1975 · S/N 177RG0744N123DSDenton Farms LLC · Williamsburg, MIBuilt 1975 · S/N 17702373N123LSBlackford Robert G · Summit Point, WVBuilt 1973 · S/N 177RG0334N123WEFogg Britt · Springdale, ARBuilt 1974 · S/N 177RG0628N1246CTriplett Michael D · Eastsound, WAS/N 17702689N124KAJohnson Michael Scott · Edgewood, TXBuilt 1974 · S/N 17702181N1255CHaslett Lisa L · Vinita, OKBuilt 1977 · S/N 17702691N1256CC177 Heavy LLC · Colfax, NCS/N 17702692N125JDLeppien John C · Alma, MIBuilt 1974 · S/N 17702130N1269CNovember 1269 Charlie LLC · East Montpelier, VTBuilt 1979 · S/N 17702693N1269RThompson Steve E · Port Angeles, WABuilt 1968 · S/N 17700625N12767Lipstreu William H · Hudson, OHBuilt 1975 · S/N 17702386N127826350 LLC · Yorklyn, DES/N 17702387N12868Gregg William V · Greensburg, PABuilt 1975 · S/N 17702390N1292CTrout Island Transit LLC · Glen Ellyn, ILBuilt 1977 · S/N 17702696N1294CJel Imaging Services LLC · Rochester, NYFirst renewal noticeBuilt 1977 · S/N 17702698N1296CLogan Tom B Trustee · Coeur D Alene, IDBuilt 1977 · S/N 17702699N12984Go Fly Az LLC · Gilbert, AZBuilt 1975 · S/N 17702394N12HBAerotechniques LLC · South Kent, CTBuilt 1977 · S/N 177RG1124N13019Plumer Eric · The Plains, VABuilt 1975 · S/N 17702395N13061Kelly Thomas E · Tequesta, FLFirst renewal noticeBuilt 1975 · S/N 17702396N13084Lutz Kelly L · Auburndale, FLBuilt 1976 · S/N 17702397N13108Registered aircraftBuilt 1976 · S/N 17702398N13128Huffman David L · Corsicana, TXBuilt 1976 · S/N 17702400N13180Skyward Fleet Solutions LLC · Granite Bay, CABuilt 1976 · S/N 17702402N13282Cook Thomas H · Harbor Springs, MIBuilt 1976 · S/N 17702406N13285Royalty Flight Solutions LLC · West Babylon, NYBuilt 1976 · S/N 17702407N132SMBartholet John C · Columbus, GABuilt 1973 · S/N 17702045N13305Harbin Michael Wade · Monahans, TXBuilt 1976 · S/N 17702409N13307Burden Richard M Trustee · Woodway, TXBuilt 1976 · S/N 17702410N13314Egan Richard G · Tallahassee, FLBuilt 1976 · S/N 17702412N13342Aog Hawaii LLC · Paia, HIBuilt 1976 · S/N 17702414N13362Edwards Samuel T · Mustang, OKBuilt 1976 · S/N 17702415N13379Gittleson Vernon H · Franklin Grove, ILBuilt 1976 · S/N 17702416N13411Leiss Todd J · Merritt Island, FLBuilt 1976 · S/N 17702419N13430Mjr Assoc LLC · Bend, ORBuilt 1976 · S/N 17702420N13454Parry Matthew J · Oxnard, CABuilt 1976 · S/N 17702423N1345CBeck Elwood M Jr · Athens, GAS/N 17702706
Back to AD 75-07-02