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.

N2855TMcgregor Thomas M · Chugiak, AKBuilt 1959 · S/N 18-7071N28560Hemphill Thomas N · Valencia, CABuilt 1977 · S/N AA5B0682N28561Carter Boys Aviation LLC · Alma, GABuilt 1979 · S/N 28-7911166N28565Jenks David R · Hernando, FLBuilt 1977 · S/N AA5B0684N28569Harper James Barry · Cimarron, NMBuilt 1977 · S/N AA5B0685N2856AOne Grand Adventure LLC · De Pere, WIBuilt 2007 · S/N 007N2856DDunn Leslie K · Scottsdale, AZBuilt 2010 · S/N 0022368N2856HFlight School 101 LLC · Winter Haven, FLS/N 28-7916482N2856KPlane Fun Inc Tr Trustee · Snellville, GABuilt 1979 · S/N 18053099N2856PHester Alan A · Battle Ground, WABuilt 1955 · S/N 22-3156N2856QFoster Aaron J · Missoula, MTBuilt 1975 · S/N U20603005N2856RDennis Billy C Jr · Scottsdale, AZBuilt 1967 · S/N 18258456N2856TGreene Thomas M · Chapel Hill, NCS/N 28-7916483N2856XHorn Paul M · Vacaville, CAS/N 17700256N2856ZCooksey Donald R · Newcastle, WYBuilt 1959 · S/N 22-6853N28572Peck Jeff · Denton, TXS/N AA5B0688N28573Bearpaw Aviation LLC · Brookfield, WIBuilt 1977 · S/N AA5B0689N28575Maxwell Jay Nate · Cookeville, TNBuilt 1977 · S/N AA5B0690N2857ADusenbury Susan B · Walnut Cove, NCBuilt 1953 · S/N 30057N2857FGarcia Gregory · Sacramento, CABuilt 1966 · S/N 18256957N2857MCoastal Air Services LLC · Hampton, SCBuilt 1977 · S/N 32-7840057N2857PSale Reported · Greeley, COSale reportedBuilt 1979 · S/N 28-7990501N2857QM3 Aviation Florida LLC · Fort Pierce, FLBuilt 1971 · S/N 17259857N2857RWilson Gary C · Lake Tapps, WABuilt 1967 · S/N 18258457N2857XWalton Wade · Downingtown, PABuilt 1979 · S/N 28R-7918179N28583Mcgee Michael R · Mamou, LABuilt 1977 · S/N AA5B0691N28584Cereal City Flying Club LLC · Battle Creek, MIBuilt 1977 · S/N AA5B0692N2858FFlying Fur LLC · Huntsville, ALBuilt 1966 · S/N 18256958N2858HSundt Daniel N Jr Trustee · Bryn Mawr, PABuilt 1979 · S/N 32-7940162N2858PSiegfried Richard W · Downers Grove, ILBuilt 1955 · S/N 22-3159N2858QKelley Aircraft LLC · Weyers Cave, VABuilt 1971 · S/N 17259858N2858RWetter Kristian · Fort Myers, FLBuilt 1967 · S/N 18258458N2858WHought Lowell T · Olathe, KSBuilt 1973 · S/N TE-927N2858ZRoberts Darren T · Vail, AZBuilt 1959 · S/N 22-6855N28591Toher Wayne R · Danbury, CTBuilt 1977 · S/N AA5B0696N28593Mcmillan David S · Rangeley, MEBuilt 1978 · S/N AA5B0697N2859FValley City Flying Club Llp · Valley City, NDBuilt 1966 · S/N 18256959N2859KHuyler John G Trustee · Bellvue, COBuilt 1979 · S/N 18053101N2859QSullivan Mark F · Cocoa Beach, FLBuilt 1971 · S/N 17259859N2859TGouda Rafik M · Rancho Cucamonga, CABuilt 1972 · S/N 28-7225254N2859WKoonce J Michael · Berkeley, CABuilt 1973 · S/N E-446N285AN285a LLC · Cincinnati, OHBuilt 2000 · S/N 123N285AAGoldrock Aviation LLC · Princeton, NJBuilt 1974 · S/N 28R-7435156N285BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2016 · S/N 2842420N285BLWingsleasing LLC · Wichita, KSBuilt 2023 · S/N 2881664N285BWWatson Alex · Chadron, NEBuilt 1961 · S/N CD-400N285CSDrury'S Journey LLC · Los Altos, CABuilt 2020 · S/N 18283095N285CVBarr Air Patrol LLC · Mesquite, TXBuilt 1997 · S/N 18280059N285DM4 Play Aviation LLC · Port Orange, FLBuilt 1997 · S/N 1236-97N285DSMonmouth Area Flying Club Inc · Lakewood, NJBuilt 2003 · S/N 40.285
Back to AD 2007-04-19 R1