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.

N4819QPuryear Rodney K · Pampa, TXBuilt 1976 · S/N 18802556TN4834QWavra Mark F · East Grand Forks, MNBuilt 1976 · S/N 18802570TN4841RBlack Gulch Aviation LLC · Polson, MTBuilt 1975 · S/N 18802360TN4842QBlack Gulch Aviation LLC · Polson, MTBuilt 1976 · S/N 18802578TN4843RFriesenborg & Larson Custom Spraying Lc · Buffalo Center, IABuilt 1975 · S/N 18802362TN4849JEast Side Mosquito Abatement District · Modesto, CABuilt 1981 · S/N 18803773TN4849QSouther Field Aviation Inc · Americus, GABuilt 1976 · S/N 18802585TN4851JAbernathy Spraying Service Inc · Tipton, OKBuilt 1981 · S/N 18803774TN4854RFisher Ag Service LLC · Cardington, OHBuilt 1975 · S/N 18802373TN4855RDefty Peter A · Visalia, CAS/N 18802374TN4863QKlamar Spraying Inc · Gatzke, MNBuilt 1976 · S/N 18802599TN4881QAir Dakota Flite Inc. · Hettinger, NDBuilt 1976 · S/N 18802617TN4890QNew Frontier Aviation LLC · Fort Benton, MTBuilt 1976 · S/N 18802626TN4890RRebecca Lynn Flying Service Inc · Livingston, NYBuilt 1975 · S/N 18802408TN4896QBecker Flying Service Inc · Hartington, NEBuilt 1976 · S/N 18802632TN4896RB&R Aerial Crop Care Inc · Connell, WABuilt 1975 · S/N 18802414TN4898QTaylor Aviation Inc · Fort Benton, MTBuilt 1976 · S/N 18802634TN4902RBecker Flying Service Inc · Hartington, NEBuilt 1975 · S/N 18802420TN4904QFoxtrot Air LLC · Highmore, SDBuilt 1976 · S/N 18802639TN4905RFlight Level Zero LLC · Othello, WABuilt 1975 · S/N 18802423TN4907RMills Spraying Service Inc · Pahokee, FLBuilt 1975 · S/N 18802425TN4908Q1lowflyer Inc · Harrisonville, MOBuilt 1976 · S/N 18802643TN4914QGudgel Daniel R · Lemoore, CABuilt 1976 · S/N 18802649N4921RBas Part Sales LLC · Greeley, COBuilt 1975 · S/N 18802438TN4927QWakefield Aircraft LLC · Cooperstown, NDBuilt 1976 · S/N 18802662TN4930RSouther Field Aviation Inc · Americus, GABuilt 1975 · S/N 18802447TN4931RRegistration Pending · Westhope, NDRegistration pendingBuilt 1975 · S/N 18802448TN4933QDarter Lloyd R · Mountain Grove, MOBuilt 1976 · S/N 18802668TN4937RAllred Bobby A · Centre, ALBuilt 1975 · S/N 18802454TN4939RMiller Farms Jv · Opheim, MTBuilt 1975 · S/N 18802456TN4944RRoma Air Corp · Belle Glade, FLBuilt 1975 · S/N 18802461TN4947QDavison Aviation LLC · Garnett, KSBuilt 1976 · S/N 18802682TN4948RBlain Monte W · Joliet, MTBuilt 1975 · S/N 18802465N4949RValley Flying Service Inc · Orleans, NEBuilt 1975 · S/N 18802466TN4958QSnider Scott E DBA · Turner, MTBuilt 1976 · S/N 18802692TN4970QPettis Ag Aviation LLC · Atlantic, IABuilt 1976 · S/N 18802704TN4991REast Side Mosquito Abatement District · Modesto, CABuilt 1975 · S/N 18802479TN4994RCountry Air Service Inc · Hecla, SDS/N 18802481TN4KLRanspot Richard · Burlington, TXBuilt 1973 · S/N 18801394N53105Pence Dale E · Garnett, KSBuilt 1974 · S/N 18801625TN53183Allred Gina D Administrator · Centre, ALBuilt 1974 · S/N 18801668TN53211Anderson Aerial Spraying Service Inc · Canby, MNS/N 18801688TN53227Birddog Aviation LLC · Stockton, KSBuilt 1974 · S/N 18801699TN53243Fly Low Aviation LLC · Ashley, NDBuilt 1974 · S/N 18801706TN53245Kirk Ben C · Louisville, MSBuilt 1974 · S/N 18801708TN53277Petecraft Aviation Services Inc · Plains, GABuilt 1974 · S/N 18801732TN53315Denton Aerial Spraying · Las Animas, COBuilt 1975 · S/N 18802213TN53319Souther Field Aviation Inc · Americus, GAFirst renewal noticeS/N 18801758TN53368Arnt Aerial Spraying Inc · Worthington, MNBuilt 1974 · S/N 18801790N53391Schwend Brian · Forsyth, MTBuilt 1974 · S/N 18801805T
Back to AD 68-07-07