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.

N291ABSerafini Louis · Ringwood, NJBuilt 1970 · S/N D-9119N2921BMurray Michael E · Fallbrook, CABuilt 1964 · S/N D-7372N2980AWest David R · Newalla, OKBuilt 1978 · S/N D-10154N29DCDwlg Aviation LLC · Rogers, ARBuilt 1965 · S/N D-7943N29VRegistered aircraftBuilt 1972 · S/N D-9340N2CBBoxman LLC · Wilmington, DEBuilt 1977 · S/N D-10090N2CSBolton Geoffrey M · Groveland, CABuilt 1973 · S/N D-9463N2DCGottsleben John J · Tucson, AZBuilt 1964 · S/N D-7318N2DNHaines Matthew E · Lake Dallas, TXBuilt 1973 · S/N D-9426N2DURegistered aircraftBuilt 1977 · S/N D-10030N2EYBender Jeffrey T · Scottsdale, AZBuilt 1967 · S/N D-8401N2JXBrookeash Inc · Waxahachie, TXBuilt 1965 · S/N D-7811N300ABDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1966 · S/N D-8056N300CLHustak Michael G · Granbury, TXBuilt 1969 · S/N D-8913N3017WKirk Michael E · Alvin, TXBuilt 1973 · S/N D9520N3023WBoughen James R · Camas, WABuilt 1973 · S/N D-9517N3032WDebrouwer Isabelle Mc · Alpine, TXBuilt 1973 · S/N D-9525N303LWHoward Dan E · Hurricane, UTBuilt 1966 · S/N D-8336N3041CVangundy Timothy S · Camby, INBuilt 1976 · S/N D9946N3041WEstes Aviation LLC · Rapid City, SDBuilt 1968 · S/N D-8824N3051AHigby James E Jr · Frederick, COBuilt 1969 · S/N D-9058N3057WBaskins Robert H · Huntington Beach, CABuilt 1973 · S/N D-9557N3064WDavid And Shirley Houchin LLC · Crescent City, FLBuilt 1973 · S/N D-9553N3092WPrimm Daniel D Jr · Lexington, KYBuilt 1973 · S/N D-9556N3099WSavage Curtis Mac · Johnstown, OHBuilt 1973 · S/N D-9561N309DCRother Michael V · Granbury, TXBuilt 1979 · S/N D-10309N30EDN30ed LLC · Carpinteria, CABuilt 1969 · S/N D-9076N30VTPlane Fun Inc Tr (Trustee) · Snellville, GABuilt 1973 · S/N D-9439N3102WBonanza Leasing LLC · Versailles, KYBuilt 1973 · S/N D-9558N3111WChubb Oil & Gas LLC · Missoula, MTBuilt 1967 · S/N D-8573N311BGBluffton Flying Service Ltd · Bluffton, OHBuilt 1971 · S/N D9276N3128WSterling Anthony K · Wilson, NCBuilt 1973 · S/N D-9564N3135WFlycarolina LLC · Concord, NCBuilt 1973 · S/N D-9538N3138WN3138w Bonanza V35b LLC · Jeffersonville, INBuilt 1973 · S/N D-9566N313DBHelm Walter · Sacramento, CABuilt 1977 · S/N D-10014N313WWilliams Thomas James · Clovis, CABuilt 1981 · S/N D-10363N3147WTadesco Rothchild LLC · Wilmington, DEBuilt 1973 · S/N D-9569N315ABColabianchi Bob J · Fountain Hills, AZBuilt 1975 · S/N D-9740N3161WPritchard Casey M · Bells, TXBuilt 1973 · S/N D-9572N3163WSkye Peak Corp · Greenfield, MABuilt 1973 · S/N D-9573N317CHCrestair Air LLC · Dover, DEBuilt 1973 · S/N D-9543N317EPMcelligott Michael J · Woodstock, VABuilt 1969 · S/N D-9044N317SCDuehring Jonathan H · Raleigh, NCBuilt 1968 · S/N D-8754N317SWMcnaughton Aviation LLC · Bondurant, IABuilt 1965 · S/N D-7854N3180WPepe Charles · Morrisville, VTBuilt 1974 · S/N D-9574N3181WNormark Jordan C · Granbury, TXBuilt 1974 · S/N D-9575N3194CNortje Bryan John · Gold Hill, NCBuilt 1967 · S/N D-8479N319RFFairfax Ronald E · Hailey, IDBuilt 1974 · S/N D-9663N31FSStrickland Corp · Onida, SDBuilt 1974 · S/N D-9586N3206LAlpha Tango LLC · Omaha, NEBuilt 1976 · S/N D-9951
Back to AD 75-01-07