OpenAirDocs.org
AD 67-29-07

Registered aircraft · 17

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:67-29-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:67-29-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.

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-4255N443FDRobertson 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-1616N752ASierra Aeronautics LLC · Franklin, KYBuilt 1957 · S/N 55981N855DBSmith David B · Yakima, WAS/N 551148N855TCSierra Aeronautics LLC · Franklin, KYBuilt 1956 · S/N 551005
Back to AD 67-29-07