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.

N3213DMountaingales LLC · Phoenix, AZBuilt 1998 · S/N E3213N3213SRosengrants Matthew R · Walsh, COBuilt 1964 · S/N 18255713N3213WElmore Terry · Berry, ALS/N 32-13N3213YFletcher Jerry D · Yukon, OKBuilt 1962 · S/N 18254213N3213ZDasher Daryl L · Boring, ORBuilt 1959 · S/N 22-7153N3214DHill James P · Eagle Point, ORS/N 18-8209025N3214FPicker Larry L · Stanfield, ORBuilt 1967 · S/N 670007N3214RLima Delta Co Trustee · New Castle, DEBuilt 1994 · S/N CE-1790N3214TJohnson Hugh S · Rochester, NYBuilt 1967 · S/N 17700514N3214UBibus Michael A · Austin, MNBuilt 1963 · S/N 18254614N3214ZYounger Aviation LLC · Poteau, OKBuilt 1994 · S/N E-2911N32151Wilson James E III · Brentwood, CAS/N 28-7505030N32156Fier Michael A Sr · Mundelein, ILBuilt 1974 · S/N 28-7525029N3215FWinick Scott R · Jay, VTBuilt 1967 · S/N 670008N3215TMcgee Debra L · Tuscola, TXBuilt 1967 · S/N 17700515N3215UAileron T LLC · Orlando, FLBuilt 1994 · S/N E-2915N3215WDiederich Chad · Chesapeake, VABuilt 1965 · S/N 32-16N3215ZCastle Richard E · Callao, MOS/N 22-7155N3216Ropp Dwight F · Pasco, WAS/N 30-796N32160Emmons Thomas M · Millington, MIBuilt 1974 · S/N 28-7525030N32161Helseth Keith A · Kirksville, MOBuilt 1974 · S/N 28-7515082N32165Cole Charles V · Sparta, TNBuilt 1974 · S/N 28-7515084N32169Airleasing LLC · Beverly Hills, CABuilt 1974 · S/N 28-7505031N3216EChrabot Gerard S · Virginia Beach, VABuilt 1978 · S/N 17271471N3216FPerry Edward Glen Trustee · Ozark, ARBuilt 1967 · S/N 670009N3216MN3216m Inc Trustee · Carson City, NVBuilt 1981 · S/N 414A0826N3216TWss Aviation Inc · Jerseyville, ILBuilt 1967 · S/N 17700516N3216ZMy Fly LLC · Wilmington, DES/N E-2922N32170Kenslow Michael · Denton, TXBuilt 1974 · S/N 28-7505032N32171Chicken Hawk Aviators LLC · Pembroke Pines, FLBuilt 1974 · S/N 28-7505033N32172International Aviation Group LLC · Lake Wales, FLBuilt 1974 · S/N 28R-7535030N32177Ace Aircraft Leasing Inc · Nazareth, PABuilt 1974 · S/N 28-7525031N32178Nebraska Generator Service LLC · Gibbon, NEBuilt 1974 · S/N 28-7525032N3217EDavis Darren · Flint, TXBuilt 1995 · S/N E-2926N3217MN3217m LLC · Polson, MTBuilt 2000 · S/N E-3317N3217SGrotbeck Christopher L · Albuquerque, NMBuilt 1964 · S/N 18255717N3217UWelkin Aero Inc · Garden Plain, KSBuilt 1975 · S/N 18502738N3217VKunkel David L · Boulder, COBuilt 2008 · S/N 26022CN3217WNorth Anthony B · Bloomfield, CTBuilt 1965 · S/N 32-19N3217YBrowne Robin P · Dallas, TXBuilt 1962 · S/N 18254217N3217ZQuality Aviation Inc · Marana, AZFirst renewal noticeBuilt 1959 · S/N 22-7158N32181Weaver James D · Montgomery, INBuilt 1974 · S/N 28-7515088N32189Long Todd A · Maple Plain, MNBuilt 1974 · S/N 28-7515090N3218DWright James Cope · Round Rock, TXBuilt 1955 · S/N 32016N3218JKanooth Steven L · Washougal, WABuilt 1966 · S/N 15065918N3218TShepherd Darren · Shepherdsville, KYBuilt 1967 · S/N 17700518N3218URadford Tara Lynn · Elmira Heights, NYBuilt 1963 · S/N 18254618N3218XMjm Flying LLC · Traverse City, MIBuilt 2000 · S/N E-3358N3218YCollins Marcus E Jr · Camilla, GABuilt 1962 · S/N 18254218N32191Czyszczon Aviation LLC · St Pete Beach, FLS/N 28-7515092
Back to AD 2007-04-19 R1