OpenAirDocs.org
AD 2007-04-19 R1

Registered aircraft · 108,428

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.

N1282RHoover Brian A · Warsaw, INS/N 4335N1282SScharfenberg Andrea · Maquon, ILBuilt 2014 · S/N 13618N1282URutledge James K Trustee · Colfax, CABuilt 1976 · S/N 17266977N1282ZBrickhouse Aviation LLC · Franklin, TNBuilt 1961 · S/N D-6711N12830All Sports Aviation LLC · Spokane, WABuilt 1973 · S/N 17262296N12831Bryant Kevin L · Terry, MSBuilt 1973 · S/N 17262297N12833Kling Aviation Inc · Friendswood, TXBuilt 1973 · S/N 17262299N12834High Flight Academy LLC · Allison Park, PABuilt 1973 · S/N 17262300N12836Schlemmer Diane · Roswell, GABuilt 1973 · S/N 17262301N1283HMurphy George W · Willow, AKS/N 15AC-299N1283RKeyser Dakota R · Ralls, TXBuilt 1966 · S/N 4330N1283UAtutis Michael F · Baldwinsville, NYBuilt 1976 · S/N 17266978N12840Lanier Aviation LLC · Cleveland, GABuilt 1973 · S/N 17262304N12849Ripa Christopher J · East Harwich, MABuilt 1973 · S/N 17262311N1284NAbnc Air LLC · Wellington, FLS/N 28-7405076N1284PTwostars Aviation LLC · New York, NYBuilt 2013 · S/N E-3988N1284TWhite Wayne A · Loyalton, CABuilt 1959 · S/N 52016N1284WBethel Don G · Bossier City, LABuilt 1967 · S/N 28R-30304N1284ZDubose Alexander R · Durham, CABuilt 1961 · S/N TD-458N1285FWill Rittner E · Sevierville, TNBuilt 1975 · S/N 18502809N1285ZRivera Luis Jr · Spring, TXBuilt 1961 · S/N TC-100N12860Solis Aviation LLC · Carroll, OHBuilt 1973 · S/N 17262319N12865Flyright Aviation LLC · Columbus, OHBuilt 1973 · S/N 17262324N12866Holmes Charles Trustee · Fort Madison, IABuilt 1973 · S/N 17262325N12867Palm Grove Development Inc · Gray, GABuilt 1973 · S/N 17262326N12868Gregg William V · Greensburg, PABuilt 1975 · S/N 17702390N1286FTaylor Aviation Inc · Mazama, WAFirst renewal noticeBuilt 1975 · S/N 18502810N1286JDillman Neal A · Davis, CABuilt 1975 · S/N 286N1286THeffelfinger Paul D · Seven Valleys, PABuilt 1972 · S/N 28-7205277N12871Bemidji Aviation Services Inc · Bemidji, MNBuilt 1973 · S/N 17262330N12872Advanced Aviation And Aircraft Rental LLC · Lawrenceville, GABuilt 1973 · S/N 17262331N12874Mentone Flying Club Inc · Rochester, INBuilt 1973 · S/N 17262333N12875Career Flight Training And Aircraft Rental LLC · Naples, FLBuilt 1973 · S/N 17262334N12876Aerolanding LLC · Enterprise, ALBuilt 1973 · S/N 17262335N12878M&M Bear Necessities LLC · Newellton, LABuilt 1973 · S/N 17262337N1287ECrown Coast LLC · Costa Mesa, CABuilt 2006 · S/N 172S10335N1287UTrekraken Aviation LLC · Scottsdale, AZBuilt 1976 · S/N 17266981N12880Aerial Holdings LLC · Lewes, DEBuilt 1973 · S/N 17262339N12883Rpm Aero LLC · Lincolnwood, ILBuilt 1973 · S/N 17262340N12884Registered aircraftBuilt 1973 · S/N 17262341N12885Above & Beyond Aviation LLC · Sandy Hook, CTBuilt 1973 · S/N 17262342N12886Wings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17262343N12887Slipstream Aviation LLC · Calera, ALBuilt 1973 · S/N 17262344N1288SFrench Oil Co · Midland, TXBuilt 1976 · S/N 18264855N1288ZWeber Colleen M · Waterford, WIBuilt 1961 · S/N CD-335N12893Weiss Lyle D · Faith, SDBuilt 1973 · S/N 17262348N12897Foothill Aircraft Sales & Service Inc · Upland, CABuilt 1973 · S/N 17262352N12898Nova Ivan · Hackensack, NJS/N 17262353N12899Lyon Kimberly J · Layton, UTBuilt 1973 · S/N 17262354N1289RLeblanc Rick M · Deerwood, MNBuilt 1972 · S/N 30417
Back to AD 2007-04-19 R1