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.

N321VESullivan Mike D · Braddyville, IABuilt 1995 · S/N DMO243N321VTWinick Scott · Jay, VTBuilt 1973 · S/N 507N321WFWings Over Texas Holdings LLC · Denton, TXBuilt 2001 · S/N 17280987N321WHBonanza Equipment Leasing LLC · Missoula, MTBuilt 1979 · S/N 18266927N321WMMartinez Jose A · Orlando, FLBuilt 1975 · S/N TH-571N321WPRadmall LLC · Commerce City, COBuilt 1995 · S/N E-2929N321WRFord Paul · Princeton, NJBuilt 2002 · S/N 0269N321WSWrong Brothers Aviation LLC · Wilmington, DEBuilt 1973 · S/N AA5-0327N321WVHill Stephen D · Lincoln, NEBuilt 2012 · S/N TH-2343N321WYWhitescarver Suzanne L Trustee · Las Vegas, NVBuilt 2016 · S/N L2K-273N321XVerrall Charles Peter Jr · Florence, AZS/N D-5990N321YZStroh Michael · Killdeer, NDS/N 28-7505039N32200Owsley Kevin · Auburn, ALBuilt 1974 · S/N 28-7525036N32204Flying Country Club Inc · Coal Valley, ILBuilt 1974 · S/N 28-7515094N32206Williams Jonathan · Meadow, TXBuilt 1974 · S/N 28-7515097N32209Mitchellville Flyers Inc · Annapolis, MDBuilt 1974 · S/N 28-7505037N3220JFagen Inc · Granite Falls, MNBuilt 1995 · S/N E-2920N3220WBarnes Matthew Thomas · Valdosta, GABuilt 1965 · S/N 32-25N3220YTanner Fred E · Westville, FLS/N 18254327N3221SPropwash LLC · Mesquite, NVBuilt 1964 · S/N 18255721N3221WRay Troy D · Roanoke, VAFirst renewal noticeBuilt 1965 · S/N 32-27N3221YRegistration Pending · Brea, CARegistration pendingS/N 18254221N32223Boehm William Dean · Baldwin, ILS/N 28-7515101N32228Segalla Susan B Trustee · Venice, FLBuilt 1974 · S/N 28-7505040N3222DBeggs Patrick C · Salem, ORBuilt 1955 · S/N 32020N3222PAmlz Air LLC · Rockville, MDBuilt 1995 · S/N EA-573N3222UMilpower Inc · Nampa, IDBuilt 1995 · S/N E-2919N3222YCreighton Andrew M · Lebanon, TNBuilt 1962 · S/N 18254222N3222ZBoggs Anthony M · Pringle, SDBuilt 1959 · S/N 22-7163N3223BTechmur LLC · Loudonville, NYBuilt 1995 · S/N E-2923N3223DCliff Robinson Real Estate Corp · Madison, INBuilt 1955 · S/N 32021N3223PPrestige Tech Consulting Inc · Carrollton, TXS/N 1181N3223TRuano Edwin B · Phoenix, AZBuilt 1978 · S/N 28-7890541N3223UPerry Joseph R · Portland, ORBuilt 1963 · S/N 18254623N32245Johnson Donald D · Scottsdale, AZBuilt 1974 · S/N 28-7515102N3224CHassebrock John M · Colorado Springs, COBuilt 1978 · S/N R18200257N3224FShaffer Aviation LLC · Keystone Heights, FLBuilt 1967 · S/N 670017N3224PEighttwotwo LLC · Wilmington, DEBuilt 2014 · S/N 73504N3224QRech Jack R · Mohave Valley, AZBuilt 1999 · S/N E3224N3224SSkylane Trio Ltd · La Junta, COBuilt 1964 · S/N 18255724N3224WMedic Choppers LLC · Springdale, ARS/N 32-31N3224YCrouchet Jay · Kremlin, MTBuilt 1962 · S/N 18254224N3224ZBagley Sherell G · Suwanee, GABuilt 1959 · S/N 22-7168N32251Kful Flyers Foudation Inc · Fullerton, CAS/N 28-7515104N32255Registered aircraftBuilt 1974 · S/N 28-7505041N32256Hasek Christopher A · Plano, TXBuilt 1974 · S/N 28-7505042N32258Wing Rentals LLC · Phoenix, AZBuilt 1974 · S/N 28-7505043N3225KWjm Aviation LLC · Friendswood, TXBuilt 1995 · S/N E-2975N3225RHansen Duane D · Rockford, ILBuilt 1969 · S/N 28R-31134N3225UBlizzard Air LLC · Midland, TXBuilt 1963 · S/N 18254625
Back to AD 2007-04-19 R1