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.

N2960DRed Baron Rentals LLC · Jacksonville, FLBuilt 1979 · S/N 28-7916590N2960PBrown Daniel A · Gettysburg, PABuilt 1955 · S/N 22-3233N2960RVarun 2016 LLC · Florence, SCBuilt 1979 · S/N 28-7911275N2960WDawson Ben J · Milton Freewater, ORS/N 1099N2960YHudson Maury B · Humble, TXBuilt 1979 · S/N 32-7940230N2961Wilbanks Kevin W · Artesia, NMBuilt 1972 · S/N 188967N29610Ammar Elias G · Colton, CABuilt 1979 · S/N 28-7911183N29617Abbott Barry · Tempe, AZS/N 17700994N29619Loudenslager Donald F · Collinsville, OKBuilt 1968 · S/N 17700996N2961AMerrill Richard C · Chuckey, TNBuilt 1953 · S/N 30161N2961BHyldburg Aviation · Plymouth, MABuilt 1979 · S/N 28-7916591N2961FNilssen Carl J · Cameron, WIBuilt 1966 · S/N 18257061N2961JFrey Jerry P · Fallon, NVBuilt 1979 · S/N T18803581TN2961PRegistered aircraftBuilt 1955 · S/N 22-3234N2961TMagnumforamen Ppg Aeroadventures LLC · Kalispell, MTBuilt 1966 · S/N 334N2961WKrauss Solutions LLC · Debary, FLBuilt 1979 · S/N 28-7916594N2961XLaurina Peter · Knoxville, TNBuilt 1967 · S/N 17700361N2961YGarcia Kale B · Covington, WABuilt 1962 · S/N 18253961N29625Sale Reported · Fort Myers, FLSale reportedBuilt 1968 · S/N 17700998N2962AKapsner Mark W · Willow, AKBuilt 1953 · S/N 30162N2962EPaulisue Aviation LLC · East Saint Louis, ILBuilt 1978 · S/N 17271388N2962FMcclevey Landon Kole · Dilley, TXBuilt 1966 · S/N 18257062N2962LAllen Marcus I · Little Elm, TXBuilt 1967 · S/N 670096N2962RHurn Enterpises LLC · Grand Beach, MIS/N 28R-35347N2962TAviation Days LLC · Ridgefield, CTBuilt 1966 · S/N 335N2962UFlake Philip · Pearland, TXS/N 28-7916598N2962XRomine John M · Broken Arrow, OKBuilt 1967 · S/N 17700362N2962ZMull Jason E · Chester, NYBuilt 1978 · S/N 379-78N29631Registered aircraftBuilt 1973 · S/N 21059873N29638Seal Seismic Service LLC · Oklahoma City, OKS/N 28R-7918155N2963CMcmillian Tommy D · Wasilla, AKBuilt 1954 · S/N 30863N2963FConnell Gary A · Anchorage, AKS/N 18257063N2963XWayner Ronald P · Sutton, AKBuilt 1967 · S/N 17700363N2963YMoretti Larry · Monroe, MIBuilt 1962 · S/N 18253963N29643Campbell Robert A · Dayton, TXS/N 17701005N29645Borgman Dale A · Rescue, CABuilt 1968 · S/N 17701006N2964CBrown A Russell · Lafayette, TNBuilt 1979 · S/N 28-7911279N2964DKluge Kris D · Mound, MNBuilt 1979 · S/N 28-7911280N2964FHunt Stuart J · Lynn Haven, FLBuilt 1966 · S/N 18257064N2964TMallard Aviation LLC · Manchester, NHBuilt 1966 · S/N 337N2964YVanderwel Paul · Woodinville, WABuilt 1962 · S/N 18253964N29651Geurs John Z · Ossian, INBuilt 1968 · S/N 17701009N2965APa 32 LLC · Union Center, WIBuilt 1979 · S/N 32-7940236N2965CBauer Joachim · Rhome, TXFirst renewal noticeBuilt 1954 · S/N 30865N2965FFrank Paul R · Waukesha, WIBuilt 1966 · S/N 18257065N2965WFly On LLC · Boise, IDBuilt 1979 · S/N 28-8090003N2965XLynch Thomas L · Fort Collins, COBuilt 1967 · S/N 17700365N29664Tyree William B · Arlington, TXBuilt 1974 · S/N 17264119N29667Viles Timothy · Bartlett, TNBuilt 1968 · S/N 17701016N2966ACroffut David P · Anchorage, AKBuilt 1953 · S/N 30166
Back to AD 2007-04-19 R1