AD 68-07-07

Registered aircraft · 284

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:68-07-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:68-07-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.

N731LACmk Aerial Inc · Sutton, NEBuilt 1977 · S/N 18802967TN731LFMcneill Dudley T · Happy, TXS/N 18802972N731MKMccormick Eugene C DBA · Tyler, ALS/N 18802999TN731MRMerced County Mosquito Abatement District · Merced, CAS/N 18803005TN731PHTorkelson Charles A · San Antonio, TXBuilt 1977 · S/N 18803044TN731PMAir Ag Inc · Tarboro, NCBuilt 1977 · S/N 18803048N731QCTim Whitfield Aviation · Fairfield, NCBuilt 1977 · S/N 18803063TN731TBEastern Flying Service Inc · Middletown, DEBuilt 1978 · S/N 18803133N731TQSnider Scott E DBA · Turner, MTS/N 18803146TN731TSSantana Hector Rafael · Crystal River, FLBuilt 1978 · S/N 18803148TN731UFPeniston Bob · Chillicothe, MOBuilt 1978 · S/N 18803160TN731VXGoff Bayou LLC · Shelby, MSBuilt 1978 · S/N 18803200TN731VYCarr Scott A · Allen, NEBuilt 1978 · S/N 18803201TN731WVKutschera Theodore C DBA · Callicoon, NYBuilt 1978 · S/N 18803222TN731XGPeniston Charles R · Chillicothe, MOBuilt 1978 · S/N 18803233TN731XNPeniston Bob · Chillicothe, MOBuilt 1978 · S/N 18803239TN731YRAbernathy Larry D · Tipton, OKBuilt 1978 · S/N 18803266N76AGSkyview Applicators LLC · Hartington, NEBuilt 1976 · S/N 18802699TN78417Mcelwain Russell D · Lancaster, KSBuilt 1974 · S/N 18801952TN788BTPowers Elbie L · Roseboro, NCFirst renewal noticeBuilt 1976 · S/N 18802583N79080Snider Roger A · Harlem, MTBuilt 1974 · S/N 18801962N79260Sale Reported · Xxx, OKSale reported, pending cancellationBuilt 1974 · S/N 18801968TN8000VCga Holdings LLC · Kalispell, MTBuilt 1967 · S/N 188-0250N8007VJcr Ag LLC · Frederick, OKBuilt 1967 · S/N 188-0257N8017VThrush Hills LLC · Volga, SDBuilt 1967 · S/N 188-0267N8018VLight Flight Ltd · Lehighton, PABuilt 1967 · S/N 188-0268N8027VWalton Philip G DBA · Mankato, KSBuilt 1967 · S/N 188-0277N8042VSale Reported · Watford City, NDSale reportedBuilt 1967 · S/N 188-0292N8045VGreater Houston Soaring Assoc · Needville, TXBuilt 1967 · S/N 188-0295N8046VSt Bernard Parish Police Jury · Chalmette, LABuilt 1967 · S/N 188-0296N8075GVaughns Flying Service Inc · Reese, MIBuilt 1973 · S/N 18801226TN8079GBoney Grady · Rhine, GABuilt 1973 · S/N 18801227TN8080VTri Rotor Spray & Chemical · Ulysses, KSBuilt 1968 · S/N 188-0330N8081VStorm Flying Service LLC · David City, NEBuilt 1968 · S/N 188-0331N8086VSchmitt Rudy · Brookshire, TXS/N 188-0336N8094GTri Rotor Spray & Chemical · Ulysses, KSBuilt 1973 · S/N 18801230N8110VN8110v LLC · Havana, FLBuilt 1968 · S/N 188-0360N8130GBank Of Utah Trustee · Salt Lake City, UTBuilt 1973 · S/N 18801243TN8147VSchmitt Rudy · Brookshire, TXBuilt 1968 · S/N 188-0397N8150VSchindler Flying Inc · Neligh, NEBuilt 1968 · S/N 188-0400N8157VReady Aim Flyer LLC · New Castle, DEBuilt 1968 · S/N 188-0407N8169VNelson Robert L · Fargo, NDBuilt 1968 · S/N 188-0419N8262GRegistration Pending · Hampshire, ILRegistration pendingBuilt 1973 · S/N 18801274N8277GCountry Aero LLC · Darwin, MNBuilt 1973 · S/N 18801281TN8288GFord Flying Service Inc · Doerun, GABuilt 1973 · S/N 18801287N8296GKiehl Austin J · Winnett, MTBuilt 1973 · S/N 18801293N84497N84497 LLC · Omaha, NEBuilt 1974 · S/N 18801989TN86407Donalds Flying Service Inc · Pantego, NCBuilt 1975 · S/N 18802013TN86440Wilde Air Service-Huron LLC · Volga, SDBuilt 1975 · S/N 18802014TN888BTSpraymax Corp · Miami, FLBuilt 1974 · S/N 18801782T
Back to AD 68-07-07