OpenAirDocs.org
AD 75-04-02

Registered aircraft · 27

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-04-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-04-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.

N111VAWeeks Kermit A · Polk City, FLBuilt 1953 · S/N 55433N1255TSierra Aeronautics LLC · Franklin, KYBuilt 1954 · S/N 55607N155GWSierra Aeronautics LLC · Franklin, KYBuilt 1955 · S/N 55883N17376Deterding Jame Louis · Pond Creek, OKS/N 1253N17758N17758 LLC · Salem, ORBuilt 1996 · S/N V55-396TN2300ZProvost Michael A · Jefferson, GABuilt 1954 · S/N 55750N2302FN2302f LLC · Salem, ORBuilt 1952 · S/N 55188N24111Sierra Aeronautics LLC · Franklin, KYBuilt 1955 · S/N 55237N2650MSierra Aeronautics LLC · Franklin, KYBuilt 1954 · S/N 55907N31611Sierra Aeronautics LLC · Franklin, KYBuilt 1956 · S/N 56-4255N32533Sierra Aeronautics LLC · Franklin, KYBuilt 1957 · S/N 55-1062N37788Valiant Air Command Inc · Titusville, FLBuilt 1957 · S/N 57-5937N443FDRobertson Donald M · Sussex, NJBuilt 1955 · S/N 55-1046N502AKProvost Michael A · Jefferson, GABuilt 1997 · S/N V55-896TN5663Sierra Aeronautics LLC · Franklin, KYBuilt 1959 · S/N 55-1267N616ZSierra Aeronautics LLC · Franklin, KYBuilt 1957 · S/N 57-1616N62206Sierra Aeronautics LLC · Franklin, KYBuilt 1961 · S/N 54-1422N62208Moss Frank V · Punta Gorda, FLS/N 57-1627N752ASierra Aeronautics LLC · Franklin, KYBuilt 1957 · S/N 55981N855DBSmith David B · Yakima, WAS/N 551148N855TCSierra Aeronautics LLC · Franklin, KYBuilt 1956 · S/N 551005N94475Sierra Aeronautics LLC · Franklin, KYBuilt 1952 · S/N 130141N95484Sierra Aerounautics LLC · Franklin, KYBuilt 1954 · S/N 54-1409N95485Sierra Aeronautics LLC · Franklin, KYBuilt 1955 · S/N 55-3217N95486Sierra Aeronautics LLC · Franklin, KYBuilt 1978 · S/N 56-1558N955TCSierra Aeronautics LLC · Franklin, KYS/N 57-5961N9894Sierra Aeronautics LLC · Franklin, KYS/N 55998
Back to AD 75-04-02