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.

N55935Teprovich Thomas J III · Peachtree City, GABuilt 1973 · S/N 28R-7335313N55938Turner Cole M · Round Rock, TXBuilt 1973 · S/N 287325536N5593BQualick Robert N · White Rock, NMBuilt 1956 · S/N 33593N5593CSouth Coast Aviation LLC · San Diego, CAFirst renewal noticeBuilt 1989 · S/N E-2493N5593DOhaike Richard O · Mansfield, TXBuilt 1957 · S/N D-5165N5593PDingus Donald E Jr · Brownfield, TXBuilt 1959 · S/N 24660N5593QBrazdys Luke V · Kingman, AZBuilt 1965 · S/N 2987N55940Zadrick Wayne J · Bristol, CTBuilt 1973 · S/N 28-7325537N55942Ray Lynn M · Cloquet, MNBuilt 1973 · S/N 28-7325538N55948N235ml LLC · Marshalltown, IABuilt 1973 · S/N 28R-7335316N5594BPara-Plane Aviation Inc · Thomasboro, ILBuilt 1956 · S/N 33594N5594CNovember Inc · Murfreesboro, TNBuilt 1991 · S/N E-2685N5594PBombo Aviation LLC · Gold Beach, ORBuilt 1959 · S/N 24-661N5594YWdw Aviation Leasing Inc · Knoxville, TNBuilt 1964 · S/N 1140329N55954Registration Pending · Jacksonville, FLRegistration pendingBuilt 1973 · S/N 28-7325539N55955Pierce Riley Deirdre · Chicago, ILBuilt 1973 · S/N 28-7325542N55958Rl Magneto LLC · Sacramento, CABuilt 1973 · S/N 28R-7335317N5595BLahn Dave R · Quincy, WABuilt 1956 · S/N 33595N5595EV & E Sunset LLC · St George, UTBuilt 1978 · S/N 17271897N5595FByrne Matthew A · West Allis, WIBuilt 1968 · S/N 28-24883N5595PCassell Joseph · Singer, LABuilt 1959 · S/N 24-662N5595QLivezey Patrick · Lithia, FLBuilt 1965 · S/N 2988N55960Gallagher Sean · Cave Creek, AZBuilt 1973 · S/N 28R-7335318N55965Greene County Flying Club · Waynesburg, PABuilt 1973 · S/N 28-7305510N55967Hisman Gary L · Skagway, AKS/N 28-7305511N55968Tindle David W · Fennville, MIFirst renewal noticeS/N JC-1N5596BFlyventure LLC · Fort Wayne, INBuilt 1956 · S/N 33596N5596DBas Part Sales LLC · Greeley, COBuilt 1957 · S/N D-5124N5596JJenny LLC · Hudsonville, MIBuilt 1968 · S/N 32-1037N5596UPine Aviation Inc · Sheridan, WYBuilt 1969 · S/N 28-26326N55970Soaring Eagle Aviation LLC · Carmi, ILBuilt 1973 · S/N 34-7350266N55973Crase Nicole Trustee · Mansfield, OHBuilt 1973 · S/N 28-7325543N55975Pena Leonardo · The Colony, TXBuilt 1973 · S/N 28-7325545N55977Walker Benjamin M · Weatherford, TXBuilt 1973 · S/N 28-7305512N55979Acumen Aerotech LLC · Rogers, TXBuilt 1973 · S/N 28R-7335321N5597BBucher Burton W · Waukegan, ILBuilt 1956 · S/N 33597N5597DReetz Bernard A · Discovery Bay, CABuilt 1957 · S/N D-5144N5597FDeardorff Karl R · San Luis Obispo, CABuilt 1968 · S/N 28-24853N5597UFejor Inc · San Juan, PRBuilt 1969 · S/N 28-26327N5597WLathrop Christopher A · Palmyra, WIBuilt 1962 · S/N 28-733N55986Turner Jeffrey K · Gastonia, NCBuilt 1973 · S/N 28R-7335322N55988Murawski Rene · Clarkston, MIBuilt 1973 · S/N 28-7325549N5598FKeran Gary R · New Holstein, WIBuilt 1976 · S/N 28-7725064N5598GNorth River Investments Inc · Palmetto, FLBuilt 1990 · S/N EA-503N5598JMakfly LLC · Chardon, OHBuilt 1968 · S/N 32-1065N5598UHilton Colby W · Amarillo, TXBuilt 1969 · S/N 28-26328N5598WBall Dontel J · Tacoma, WAS/N 28-734N55990Registered aircraftN-number assigned, not yet registeredS/N 28R-7335323N55996Mcfarlane Randall C · Loudonville, NYBuilt 1973 · S/N 28R-7335325N5599BMccain David O · Ashville, ALBuilt 1980 · S/N 0828
Back to AD 2007-04-19 R1