AD 67-29-01

Registered aircraft · 1,185

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

N1208ZMaurice L Prince Jr Pc · Lafayette, LABuilt 1961 · S/N TC-60N120BSkysuite Aviation LLC · Tujunga, CABuilt 1962 · S/N TC-230N1215TShepphird John C · Reno, NVBuilt 1966 · S/N TE-102N121BWLester Jon M · Lancaster, OHBuilt 1979 · S/N TC-2256N121LGPayton Kathleen · Grand View, IDBuilt 1964 · S/N TC-777N1223Z2dwh LLC · Katy, TXBuilt 1961 · S/N TC-67N122PGMcgaw Thomas D · Petaluma, CABuilt 1961 · S/N TC-149N122RLJenaero LLC · Cincinnati, OHBuilt 1978 · S/N TC-2177N123AKOptima Aviation LLC DBA · Lewisville, TXBuilt 1973 · S/N TC-1543N123JJRotorwings Aviation LLC · Hebron, NEBuilt 1972 · S/N TC-1421N1244YBurbank Dennis · Arcadia, OKBuilt 1966 · S/N TE-253N124AWCyalco Aviation LLC · Spencer, IABuilt 1965 · S/N TC-942N124BZFerguson Steven L · Rawlins, WYBuilt 1961 · S/N TC-78N124VLeach Manuel R · Natchitoches, LABuilt 1964 · S/N TC-747N1265ZGertsen Ronald H · Glenwood, NJBuilt 1961 · S/N TC-111N1268ZTodd Cori L · Gladewater, TXBuilt 1961 · S/N TC-84N1269ZChilds Lowell R · Elgin, ILBuilt 1961 · S/N TC-85N127FCalifornia In Nice Inc · San Jose, CABuilt 1965 · S/N TC-869N127RWWindmiller David · Melville, NYBuilt 1976 · S/N TC-1958N1285ZRivera Luis Jr · Spring, TXBuilt 1961 · S/N TC-100N129QFlying J Aviation Pllc · League City, TXS/N TC-847N129STAzell LLC · Springfield, MOBuilt 1965 · S/N TC-835N12BGFull Scale Aviation LLC · Mccordsville, INBuilt 1982 · S/N TC-2412N12DKTim Cross Aviation LLC · Tucson, AZBuilt 1967 · S/N TE-290N12MTRegistration Pending · Mount Vernon, IARegistration pendingBuilt 1978 · S/N TC2119N12WLLauterbach Christian · Carmel, CABuilt 1975 · S/N TC-1870N1302ZPlaisier Matthew · Lafayette, TNBuilt 1961 · S/N TC-173N1305ZReynolds James Patrick · Lebanon, TNBuilt 1961 · S/N TC-119N1307Brian Michael L · Greensboro, NCBuilt 1969 · S/N TC-1307N1311ZJprg Aviation Inc · Orlando, FLBuilt 1961 · S/N TC-120N1315ZRiesbeck Randall C · Waynesville, OHBuilt 1961 · S/N TC-123N131FHappy Star LLC · Baxley, GABuilt 1963 · S/N TC-538N132TWRc Flyers LLC · Wilmington, DEBuilt 1974 · S/N TC-1654N1332ZUp And Up Aviation LLC · Spring, TXBuilt 1961 · S/N TC-141N1333Beech Nut Flyers LLC · San Diego, CABuilt 1968 · S/N TC-1100N1339ZSmith Derek D · Brooks, GABuilt 1961 · S/N TC-139N133MRPrecision Aero LLC · Wilmington, DEBuilt 1978 · S/N TC-2173N134CBGlobal Coin Logistics LLC · Lexington, KYBuilt 1967 · S/N TG-40N134FLift Enterprises LLC · Lynn Haven, FLBuilt 1964 · S/N TC-816N1351ZErickson David R · West Point, UTS/N TC-148N1357ZBromschwig Eric I · Montgomery, TXFirst renewal noticeS/N TC-157N1365ZSkans David K · Henderson, NVBuilt 1961 · S/N TC-160N1366ZPfetsch Mitchell R · Daggett, CABuilt 1961 · S/N TC-166N1377ZCoen Brady · Wiley, COBuilt 1961 · S/N TC-165N137FSmith Nathan · Citra, FLBuilt 1956 · S/N TE-32N138QKyff Jeffrey V · Traverse City, MIBuilt 1964 · S/N TC-612N139PTCroley John T Jr · Fitzgerald, GABuilt 1964 · S/N TC-758N139QMoles Timothy E · New Cumberland, WVBuilt 1964 · S/N TC-638N1403G1403g LLC · Wheat Ridge, COBuilt 1961 · S/N TC-227N1409GAir Care Leasing LLC · Lamar, COBuilt 1961 · S/N TC-233
Back to AD 67-29-01