AD 2007-04-19 R1

Registered aircraft · 108,434

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:2007-04-19-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:2007-04-19-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.

N2673DAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1979 · S/N 340A0755N2673GChapman Chad · San Antonio, TXBuilt 1959 · S/N 51973N2673RDouville Laura Deluea · Portland, ORBuilt 1967 · S/N 18258373N2673SWilliams Randall S · Chico, CABuilt 1976 · S/N 21061348N2673TZweig William D · Chesterfield, MOBuilt 1972 · S/N 28-E11N2673WAdolf Charles P · Ocala, FLBuilt 1966 · S/N 996N2673ZFiske James K · North Andover, MABuilt 1963 · S/N 185-0673N26743Lian Jay · Gold Beach, ORBuilt 1978 · S/N AA5A0686N26744Flying Tigers Flight School Ltd · Houston, TXBuilt 1978 · S/N AA5A0688N2674CTri County Sprayers Inc · Hamlin, TXBuilt 1955 · S/N 35074N2674TCosgrove John W · Lake Ariel, PABuilt 1971 · S/N 28-7205075N2674WHough Publishing LLC · Atlanta, GABuilt 1966 · S/N 997N2674XKaiser Eric J · Milford, INBuilt 1966 · S/N P206-0174N26757Terranova Jay · Lawrenceville, GAS/N AA5A0695N26758Cooley Carolyn A · Bonifay, FLBuilt 1978 · S/N AA5A0696N2675DPaige Barry Wayne · Wasilla, AKBuilt 1952 · S/N 20827N2675FVarnado Matthew G · Denham Springs, LABuilt 1965 · S/N 18256775N2675TMahoney Dustin G · Lakewood, COBuilt 1971 · S/N 28-7225084N26760Davis Dana J · Pismo Beach, CABuilt 1978 · S/N AA5A0699N26768Cheetah268 LLC · Kailua Kona, HIBuilt 1978 · S/N AA5A0704N2676BKero Jet Corporation · Montgomery, TXBuilt 1979 · S/N 340A0762N2676GHolland Ross D · Guymon, OKBuilt 1959 · S/N 51976N2676KFurey Michael J · Hazlehurst, MSS/N 18053033N2676RStauter Michael D · Idabel, OKBuilt 1979 · S/N 340A0765N2676TMills Nicolas A · Greenwood, NYBuilt 1971 · S/N 28-7205074N2676YHands Holdings · Newark, DEBuilt 1981 · S/N 414A0631N2676ZFlynn Steven W · Bushnell, FLBuilt 1977 · S/N 1008-78N26770Tuan Vo · Falls Church, VABuilt 1978 · S/N AA5A0705N26778N26778 LLC · Santa Monica, CABuilt 1978 · S/N AA5A0714N2677FNeu Aviation LLC · Benton, LABuilt 1965 · S/N 18256777N2677GPeterson Barbara A · Cheney, KSBuilt 1959 · S/N 51977N2677KAeropod Inc · Aurora, COS/N 18053034N2677ST&D Janitorial Services LLC · Dexter, MOBuilt 1988 · S/N 89-301003N2677TDaggett Truck Lines Inc · Frazee, MNBuilt 1971 · S/N 28-7205077N2677WSaunders Charles A · Scott Depot, WVBuilt 1966 · S/N 3318N2677XHawk Jeff · Flowermound, TXBuilt 1965 · S/N P206-0177N2677YHracha Deanna L · Palmer, AKBuilt 1963 · S/N 18051177N2677ZWillkris Aviation Services LLC · Smithfield, VAS/N 1018-78N26780Campbell Joseph · Niceville, FLBuilt 1978 · S/N AA5A0715N26781Landon Easton Jeffrey Allen · Dresden, TNBuilt 1978 · S/N AA5A0716N26784Texas Cheetah LLC · Sugar Land, TXS/N AA5A0717N26788Redwood Aircraft LLC · Santa Rosa, CABuilt 1978 · S/N AA5A0722N2678SHardy Mikel Gareth · Thatcher, AZBuilt 1973 · S/N 18502265N2678TTekforce LLC · Boca Raton, FLBuilt 1971 · S/N 28-7205078N2678WLansford Company Inc · Lampasas, TXBuilt 1966 · S/N 999N2678XStewart Jeffrey D · Snyder, TXBuilt 1965 · S/N P206-0178N2678ZKing Canyon Buffalo Inc · Denver, COFirst renewal noticeBuilt 1990 · S/N 90-301010N26792Mayer David J · Ingleside, ILBuilt 1978 · S/N AA5A0725N26793Registered aircraftBuilt 1978 · S/N AA5A0727N26794Seveca Ventures LLC · Arcola, TXBuilt 1978 · S/N AA5A0728
Back to AD 2007-04-19 R1