AD 71-09-07 R1

Registered aircraft · 1,686

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:71-09-07-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:71-09-07-R1')
  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.

N6736RD Kevin Lester Md Inc · Fresno, CABuilt 1966 · S/N T210-0136N6737RJpk LLC · Waterloo, NEBuilt 1966 · S/N T210-0137N673DKBh Aero LLC · Hanover, MNBuilt 1979 · S/N 21063479N6743RBas Part Sales LLC · Greeley, COBuilt 1966 · S/N T210-0143N6745RHurt Todd A · Springfield, ORBuilt 1966 · S/N T210-0145N6746RSchwartz Daniel T · Meeker, COBuilt 1966 · S/N T210-0146N6749RPmbarrett Aviation LLC · Tucson, AZBuilt 1966 · S/N T210-0149N6753RCooper Melvyn R Jr · Albany, GAFirst renewal noticeBuilt 1966 · S/N T210-0153N6754RJarvis Ronald Louis · Gig Harbor, WABuilt 1966 · S/N T210-0154N6757RRock Air LLC · Round Mountain, NVS/N T210-0157N6759RRegistered aircraftS/N T210-0159N6761RPerini Mark J · Greenleaf, IDBuilt 1966 · S/N T210-0161N6769RDomingues Silvio · Woodland, ALBuilt 1966 · S/N T210-0169N6777RMarsh John E · Washington, DCS/N T210-0177N6779BRegistered aircraftBuilt 1978 · S/N 21062829N6780RC2 Aero LLC · Dallas, TXBuilt 1966 · S/N T210-0180N6782RReavis Paul B · Gatesville, TXBuilt 1966 · S/N T210-0182N6783RHarness Jesse J · Peoria, AZBuilt 1966 · S/N T210-0183N6784RVolk Kenneth L · Waskom, TXBuilt 1966 · S/N T210-0184N6785RRood Enterprises LLC · Livingston, TXBuilt 1966 · S/N T210-0185N6787RJensen Leland · Idaho Falls, IDBuilt 1966 · S/N T210-0187N6789RDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N T210-0189N6793RDelevie Mark Y · Tucson, AZBuilt 1966 · S/N T210-0193N6797RJts Management Inc · Lincoln, NEBuilt 1966 · S/N T210-0197N67BL206 LLC · Keizer, ORBuilt 1967 · S/N P206-0397N67CHPrestige Aviation LLC · Lake Havasu City, AZBuilt 1981 · S/N 21064354N6802RStahla Robert E Trustee · Grand Island, NEBuilt 1966 · S/N T210-0202N6803RN6803r LLC · Kent, OHBuilt 1966 · S/N T210-0203N6808NSwan Air LLC · Perham, MNS/N 21063154N6816BMystic Dreams LLC · Mount Juliet, TNBuilt 1978 · S/N 21062837N6824RSquadron 5 Inc · Saratoga, CABuilt 1966 · S/N T210-0224N6826BDan Howard Aircraft Sales LLC · Tulsa, OKBuilt 1978 · S/N 21062840N6830RElizalde Carla Zankiz · Estero, FLBuilt 1967 · S/N T210-0230N6832RWheeler David G Jr · Chico, CAS/N T210-0232N6843RArkansas Air LLC · Jackson, WYBuilt 1966 · S/N T210-0243N6847RAlpine Aviation LLC · Oklahoma City, OKFirst renewal noticeBuilt 1967 · S/N T210-0247N684MCT&B Aero LLC · Jacksonville, FLS/N 21061604N684SSecond Wind Aviation Corp · Friday Harbor, WABuilt 1969 · S/N 20700147N6850BJennings Donald J · Gypsum, COS/N 21062845N6851R6851r LLC · Greeley, COS/N T210-0251N6852RJensen Sid R · Idaho Falls, IDBuilt 1967 · S/N T210-0252N6855RD & N Holdings Inc · Boca Raton, FLBuilt 1967 · S/N T210-0255N6857RRegistered aircraftBuilt 1967 · S/N T210-0257N6859RRomeo Airmotive LLC · Stockton, CABuilt 1967 · S/N T210-0259N685GTEatmb Air Inc Trustee · Wilmington, DEBuilt 1979 · S/N 21063361N6861RJohnson Bradley Michael · Belgrade, MTBuilt 1967 · S/N T210-0261N6864RRankin Bryan · Cloverdale, CABuilt 1967 · S/N T210-0264N6866ROrnes W Harold · Aiken, SCBuilt 1967 · S/N T210-0266N6868RChrisman Charles Griggs · Denver, COS/N T210-0268N6870MApplied Science Services Corp · Woodland Hills, CABuilt 1977 · S/N 21061998
Back to AD 71-09-07 R1