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.

N5508SKimmel Frank S III · Greenwood, MSS/N 188-0008N5517SRussell Charles B · Union City, TNBuilt 1966 · S/N 188-0017N5523SDj Flight Service LLC · Little Falls, MNBuilt 1966 · S/N 188-0023N5539SLm Air Patrol Service Inc · Wink, TXBuilt 1966 · S/N 188-0039N5642JGreater Houston Soaring Association · Needville, TXBuilt 1969 · S/N 18800592N5647GDarter Lloyd R · Mountain Grove, MOBuilt 1973 · S/N 18801129N5665JFarwest Aviation LLC · Billings, MTBuilt 1970 · S/N 18800615N5670JBank Of Utah Trustee · Salt Lake City, UTBuilt 1969 · S/N 18800620N5680JKnutson Wayne R · Thompson, NDBuilt 1970 · S/N 18800630N5685JAnderson Aerial Spraying Service · Canby, MNBuilt 1970 · S/N 18800635N5688JAnderson Aerial Spraying Service Inc · Canby, MNBuilt 1970 · S/N 18800638N5697JRidgway Rick J · Carlisle, INBuilt 1970 · S/N 18800647N5708GAir Dakota Flite · Hettinger, NDBuilt 1973 · S/N 18801138N58235Collins Wayne J · Lubbock, TXBuilt 1966 · S/N 188-0033N5987GSchwend Brian · Forsyth, MTBuilt 1973 · S/N 18801166N6032RMatecumbe Flying Service Inc · Immokalee, FLBuilt 1976 · S/N 18802734TN6048GWitthuhn Johnie B · Callaway, NEBuilt 1973 · S/N 18801172TN6133GRosebud Aviation · Gregory, SDBuilt 1973 · S/N 18801176N6509GMehling Robert C · Hardin, MTS/N 18801202N6606QAirtrust LLC - 1 - Series 1 Trustee · Sheridan, WYBuilt 1977 · S/N 18802951TN6607BWhalen Mark P · Millington, MDBuilt 1977 · S/N 18802984TN6623GMehling Robert C · Hardin, MTS/N 18801208N6656GCommonwealth Of Massachusetts · Plymouth, MABuilt 1973 · S/N 18801210N666JBCopenhaver Tracy K · Anthony, KSBuilt 1973 · S/N 18801427N685JMBallard Aviation · Waynesville, MOBuilt 1974 · S/N 18801992N6872GVortex Aircrafts Inc · Port Saint Lucie, FLBuilt 1973 · S/N 18801215N70063Welch Thomas R DBA · Modesto, CABuilt 1974 · S/N 18801827TN70141Priewe Flying Service LLC · Como, MSBuilt 1974 · S/N 18801847TN70231Low Level Aero LLC · Myakka City, FLBuilt 1974 · S/N 18801873TN70288Dakota Aircare Inc · Wagner, SDBuilt 1974 · S/N 18801879TN70326Triple E Farms LLC · Peculiar, MOBuilt 1974 · S/N 18801887TN70350Bigwings Ag Inc · Delavan, MNS/N 18801895TN70387Becker Flying Service Inc · Hartington, NEBuilt 1974 · S/N 18801905N70403Mccormick Eugene C DBA · Tyler, ALBuilt 1974 · S/N 18801912TN72091Peralta Jose Ramon · Sinking Spring, PAFirst renewal noticeBuilt 1974 · S/N 18801943TN72947Greer Glenn M · Eugene, ORBuilt 1972 · S/N 18800947N731ABA & C Ag Aviation Inc · Unadilla, GABuilt 1976 · S/N 18802735TN731BGKutschera Theodore C DBA · Callicoon, NYBuilt 1976 · S/N 18802763TN731BMBenaiah Holdings Corp · Marion, KYS/N 18802768TN731CENoe Aviation LLC · Vinton, IABuilt 1976 · S/N 18802785TN731CQD & K Aviation Inc · Milford, IABuilt 1977 · S/N 18802794TN731ECFitchett Bradley S DBA · Ellsworth, KSS/N 18802830N731EQUnited States Department Of Agriculture · Edinburg, TXBuilt 1976 · S/N 18802843TN731ESSky Tech Inc · Dorchester, NES/N 18802845TN731FMNew Frontier Aviation LLC · Fort Benton, MTBuilt 1977 · S/N 18802862TN731FPLihs Ryan J · Sioux City, IABuilt 1977 · S/N 18802864TN731GDRegistration Pending · Walnut, ILRegistration pendingBuilt 1977 · S/N 18802877TN731GPUpshaw John L Jr · Claude, TXBuilt 1977 · S/N 18802887TN731GTDigger Dougs Crop Dusting Services Inc · Hollandale, WIBuilt 1977 · S/N 18802891TN731KWVann Dudley C DBA · Greenville, NCBuilt 1977 · S/N 18802963T
Back to AD 68-07-07