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.

N287JTA W Aviation · Sevierville, TNBuilt 1953 · S/N G-287N287KMO'Connor Thomas F · Plano, TXBuilt 1980 · S/N TJ-330N287LUS Department Of The Interior · Boise, IDBuilt 2014 · S/N CC18-0071N287LHJft Re Development LLC · Bentonville, ARBuilt 2024 · S/N 2787N287LMDjc Bonanza LLC · Stuart, FLBuilt 1994 · S/N E-2859N287MCValiair Lc Trustee · Casper, WYBuilt 2001 · S/N 25045CN287MSKelly Francis · El Paso, TXBuilt 2002 · S/N 24951N287PN8297n LLC · Evansville, INBuilt 1968 · S/N 28-24806N287PASkywest Leasing Inc · St George, UTBuilt 2002 · S/N 4496110N287PJWaterbury Craig A · El Paso, TXBuilt 1994 · S/N 5287N287PSSides Michael E · Bartley, NEBuilt 2022 · S/N 1130N287TCAiv Con Inc · Charlevoix, MIBuilt 1969 · S/N 18260183N287VCGreat Sky LLC · Brooklyn, NYBuilt 1979 · S/N 28-7911231N28800El Tigre Aviation LLC · Brookfield, WIS/N AA5B0821N28803Candeletti James J · Forked River, NJBuilt 1978 · S/N AA5B0823N28806Creisler Vincent L · Kent, WABuilt 1978 · S/N AA5B0825N28807Haight Donald E · Trumbull, CTBuilt 1978 · S/N AA5B0826N28808Aba Aviation LLC · Buford, GABuilt 1987 · S/N 1010N28809Cox Terry J Trustee · Missouri City, TXBuilt 1978 · S/N AA5B0833N2880EDemulling Michael C · New Richmond, WIBuilt 1978 · S/N 17271358N2880PSaalsaa Brad · Ketchikan, AKBuilt 1955 · S/N 18-4477N2880RPhelps Thomas J · Orem, UTBuilt 1967 · S/N 18258480N2880TVuppala Kavya · Springtown, TXBuilt 1972 · S/N 28R-7235151N2880XGerstung Dennis R · Anchorage, AKBuilt 1967 · S/N 17700280N2880YRegistered aircraftBuilt 1962 · S/N 18253880N28810Air & Road Sports Inc · Las Vegas, NVBuilt 1978 · S/N AA5B0834N28811B D Aviation LLC · Sauget, ILBuilt 2004 · S/N 17281232N28815Registered aircraftBuilt 1978 · S/N AA5B0836N28819Sun Samuel K · San Diego, CABuilt 1978 · S/N AA5B0838N2881FAirplanes Over Niagara LLC · Lewiston, NYBuilt 1966 · S/N 18256981N2881GGardocki Joseph E · Oklahoma City, OKBuilt 1979 · S/N 32-7940177N2881PChicago Glider Club · Minooka, ILBuilt 1987 · S/N 1011N2881QNeenah Aircraft Leasing LLC · Neenah, WIBuilt 1971 · S/N 17259881N2881ZHoag Peter J · Arlington Heights, ILBuilt 1979 · S/N 32-7940181N28820Elite Flying Group LLC · Northampton, MABuilt 1987 · S/N 1014N2882CG & M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N 44-7995302N2882RPostlewait Logging Co · Port Allegany, PABuilt 1969 · S/N 28R-35317N2882TParis Air Inc · Vero Beach, FLBuilt 1972 · S/N 34-7250180N2882WWholey James · Saratoga, CABuilt 1973 · S/N E-452N2882YVx Aviation LLC · Palisade, COBuilt 1962 · S/N 18253882N28831Stewart William G · Thousand Oaks, CABuilt 1978 · S/N AA5B0842N28834Vogel Victor H Trustee · Loveland, OHBuilt 1978 · S/N AA5B0844N28838Giuffre Matthew S · The Villages, FLBuilt 1978 · S/N AA5B0726N28839Turgeon Douglas · Anderson, SCBuilt 1978 · S/N AA5B0846N2883RCallegari Sergio P · Reno, NVBuilt 1967 · S/N 18258483N2883TGolembiewski William · Hookstown, PABuilt 1972 · S/N 28-7225265N2883XRamano Raymond C · Napa, CABuilt 1967 · S/N 17700283N2883ZFoster Gary E · Kress, TXBuilt 1959 · S/N 18-7045N28842Turnquest Joad · Sanford, NCBuilt 1979 · S/N 28-7916417N28847Mayeda Ronald K · Foster City, CABuilt 1978 · S/N AA5B0851
Back to AD 2007-04-19 R1