OpenAirDocs.org
AD 76-23-01

Registered aircraft · 35

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:76-23-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:76-23-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.

N12CJPerskys Air Service Inc · Lapine, ALBuilt 1969 · S/N 4-184N205ABAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1966 · S/N 211N208EZFesta Nerio F · Penngrove, CAS/N 2-24N2174BReid Charles A · Hamburg, NJBuilt 1968 · S/N 393N23RMiller Boyd A · Mexia, TXBuilt 1969 · S/N 4-188N260MTCarlomagno Kent Gene · San Rafael, CABuilt 1972 · S/N 3-80N266SFEastern Stearman Inc Trustee · Leesburg, VABuilt 1969 · S/N 2-29N2830WWingate Barry · Dayton, NVBuilt 1969 · S/N 4-187N2832WIbrahim Phillip · Whitinsville, MABuilt 1969 · S/N 4-189N29FCrawford Everette P · Columbia, LABuilt 1969 · S/N 4-179N366KWPlane Fun Inc Tr Trustee · Snellville, GABuilt 1967 · S/N 383N451YWSzymanski Tadeusz C · Fort Myers, FLS/N 4-143N517PSemonian Gary A · Jasper, GAS/N 106N701RGSchoepflin Robert Dennis · Palouse, WAS/N 11-10N718ABIbrahim Phillip · Whitinsville, MABuilt 1968 · S/N 4-178N730WHoelzen Robert D Trustee · Kent, WABuilt 1968 · S/N 109N733WDavenport Clifford M · Bonita, CABuilt 1968 · S/N 4-142N735WHampton Russell A · El Reno, OKBuilt 1968 · S/N 4-144N736WDevries Arthur C DBA · Coon Rapids, MNBuilt 1968 · S/N 4-145N7895Matukaitis William K · Millbury, MABuilt 1968 · S/N 123N797MSWilliamson Marc R · Parkville, MOBuilt 1969 · S/N 2-28N917ABIbrahim Phillip R · Whitinsville, MAS/N 4-185N93225Dr Carlton N Walker Dds LLC · Roswell, NMS/N 104N942TALost Squadron Inc · Wilmington, DEBuilt 1971 · S/N 11-11N943TADe Peyster Francis V · Canby, ORBuilt 1970 · S/N 11-01N945TADms Aviation Services LLC · Wildwood, MOS/N 11-04N946WBettylou Inc · Tomball, TXBuilt 1968 · S/N 4-146N948WWinston Tripp Aviation LLC · Easley, SCBuilt 1968 · S/N 4-148N970WAGavalis Joseph R Jr · Pottsville, PABuilt 1967 · S/N 379N972WASmith Brandt J · Parkers Prairie, MNS/N 381N982WAJts Aircraft LLC · Rock Hill, SCBuilt 1967 · S/N 370N985WADevries Arthur C DBA · Coon Rapids, MNBuilt 1968 · S/N 385N986WAWinter Scotty W · Gatesville, TXBuilt 1967 · S/N 386N989WAHartz Jeffrey W · Pahrump, NVBuilt 1968 · S/N 389N992WAZeissner Douglas K · Chino, CABuilt 1967 · S/N 372
Back to AD 76-23-01