AD 68-07-08

Registered aircraft · 196

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

N411CBOsky Deuce LLC · Saguache, COBuilt 1968 · S/N 2037CN4159CPerkins Kenneth D II · Eagle River, AKBuilt 1962 · S/N 9N4550RCarpenter Kevin C · Dallas, TXS/N 2017CN4602TPyles Nathan C · Ypsilanti, MIBuilt 1964 · S/N 84N4604TWeitemier Stanley G · Wadena, MNBuilt 1965 · S/N 1017N4607TPbk Aviation LLC · Jefferson, GABuilt 1965 · S/N 1020N4609TLamoureux Nicholas J · Moab, UTBuilt 1965 · S/N 1024N4612TWeaver Matthew B · Kasilof, AKS/N 1001CN4613TSullivan William R II · Sierra Vista, AZBuilt 1965 · S/N 1028N4614TOdonnell Daniel V · Dover, DEBuilt 1965 · S/N 1022N4617THuttunen Leslie M · Wasilla, AKS/N 1031N4618TWoolston Evan K · Belle Fourche, SDBuilt 1965 · S/N 1029N4619THurlbert Michael L · Wasilla, AKBuilt 1965 · S/N 87N4621TIrby Donald K · Cushing, TXBuilt 1965 · S/N 1033N4623TCorey Glenn M · Wilsonville, ORS/N 91N4624TEisel Adam A · Copenhagen, NYBuilt 1965 · S/N 1026N4700TGoulet Jason · Angle Inlet, MNBuilt 1963 · S/N 43N4701TOsborne Richard N · Roscoe, TXBuilt 1963 · S/N 44N4703TByrnes Patrick R · Nampa, IDBuilt 1963 · S/N 46N4706TMaule Susan · Media, PAFirst renewal noticeBuilt 1963 · S/N 48N4711TDelaney Spencer R · Fairfield, CABuilt 1963 · S/N 54N4712TKilcourse Jeffrey Kenneth · Tequesta, FLBuilt 1964 · S/N 55N4713TMichigan Air Service Corp · Troy, MIBuilt 1964 · S/N 56N4714TJed Homes Inc · Lisbon, CTBuilt 1964 · S/N 57N4717TStartin Tyler D · Colfax, WABuilt 1964 · S/N 60N4718TArcand David R · Forest Lake, MNBuilt 1964 · S/N 61N4727TRimediare Aircraft LLC · Tucson, AZBuilt 1964 · S/N 70N4729TNevergall Michael · Brighton, COBuilt 1964 · S/N 72N4730TEgge Danny C · Pelican Rapids, MNBuilt 1964 · S/N 73N4733TMacneil David · Clarkston, WABuilt 1964 · S/N 83N4734TSmiley Mark R · Baden, PABuilt 1964 · S/N 78N4736TLb Aero Services Inc · Poplar Grove, ILBuilt 1964 · S/N 80N4737TFly Buys Inn · Wilmington, DES/N 81N4739TJohn Ross St · Anchorage, AKS/N 1003N4740TGerdes Douglas R · Macon, GAS/N 1004N4743TWeaver Matthew B · Kasilof, AKBuilt 1964 · S/N 1008N4744TKolp Mark H · Andrews, TXFirst renewal noticeBuilt 1964 · S/N 1010N4745TLee Andrew L · Anchorage, AKBuilt 1965 · S/N 1015N4747TRegistered aircraftBuilt 1965 · S/N 1013N474WH&H Restoration LLC · Wasilla, AKS/N 2027CN51127Elsner Henry · Greensboro, NCBuilt 1973 · S/N 2188CN51207Crosswind Ventures LLC · Carson City, NVBuilt 1973 · S/N 2186CN51229Rossettie Thomas P · Manchester, MIS/N 1087CN51273Stieler Paul O · Albert Lea, MNBuilt 1973 · S/N 1089CN51407Soper Steven Trustee · Rathdrum, IDBuilt 1973 · S/N 1090CN51419Registration Pending · Port Orchard, WARegistration pendingBuilt 1973 · S/N 1093CN51425Black James P · Kooskia, IDBuilt 1973 · S/N 1095CN51430Burke Warren V · Lakewood, COBuilt 1973 · S/N 1097CN51436Boardman Danvers · Talkeetna, AKFirst renewal noticeBuilt 1973 · S/N 1101CN51445Lanier John L · Madison, ALBuilt 1973 · S/N 1106C
Back to AD 68-07-08