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.

N4964LMcallister Robert G · Santee, CABuilt 1967 · S/N 28-4335N4964YFowler Larry K · Harrison, ARBuilt 1968 · S/N 25-4676N4965Hickel Raymond E · Anchorage, AKBuilt 2000 · S/N 025N4965LCentral Air Parts Inc · Staunton, ILS/N 28-4336N4965NDowner Michael · Scottsdale, AZBuilt 1979 · S/N 18267487N4965PKittner Robert T · Ellenville, NYBuilt 1963 · S/N 27-566N4966E4966e LLC · Kalispell, MTBuilt 1956 · S/N 33000N4966GSonger Charles W III · Tuscaloosa, ALBuilt 1979 · S/N 17273513N4966LNelson Osea C · Sheridan, WYBuilt 1967 · S/N 28-4337N4966SMonkey Butler LLC · Pacifica, CABuilt 1980 · S/N R18201495N4966YSchmitt Rudy · Brookshire, TXBuilt 1968 · S/N 25-4767N4967DSchmieding Michael A · Salem, ORBuilt 1958 · S/N 51067N4967FMile Hi Skydivers Inc · Longmont, COBuilt 1966 · S/N U206-0667N4967JB F D Inc · Newington, CTBuilt 1968 · S/N 28R-30718N4967KBrown Lawson M II DBA · San Diego, CABuilt 1979 · S/N P21000386N4967NKubinski Kenneth B · Eastover, NCS/N 790066LFN4967SLambert Enterprises Inc · Minneapolis, MNS/N 28R-35687N4967TN4967t LLC · Evansville, INBuilt 1972 · S/N 28R-7235164N4968AD&B Aircraft Leasing LLC · Anchorage, AKBuilt 1956 · S/N 32365N4968DNelson Scott D · Blackfoot, IDBuilt 1958 · S/N 51068N4968JOperation Stinky Weasel LLC · South Lyon, MIBuilt 1968 · S/N 28R-30719N4968LSchoolcraft William F · Middletown, OHBuilt 1967 · S/N 28-4339N4968NConfarotta Todd A · Mount Pleasant, SCBuilt 1979 · S/N 18267489N4968UGreen Brandon K · Eufaula, ALBuilt 1965 · S/N 21058668N4969DFarwick Kobbe L · Lenexa, KSS/N 51069N4969ECapricorn Equipment Co · Madisonville, KYBuilt 1978 · S/N 17271685N4969GSanford Aircraft LLC · Winter Springs, FLBuilt 1979 · S/N 17273516N4969LLubnau Berdy G · New Braunfels, TXBuilt 1967 · S/N 28-4341N4969NGreen Michael P · Thomaston, CTBuilt 1979 · S/N 18267490N4969UTallgrass Aviation LLC · Sharon Springs, KSBuilt 1965 · S/N 21058669N496CDCirrus Skies LLC · Clayton, MOBuilt 2005 · S/N 1612N496DHeritage Air LLC · Anchorage, AKBuilt 2008 · S/N 12324N496DCB & Pb LLC · Mentor, OHBuilt 2006 · S/N E3741N496DEHegedus Bruce Alan · Anchorage, AKBuilt 1996 · S/N 29-0082N496DSDelaware State University · Dover, DEBuilt 1993 · S/N 2816105N496ECHatfield James D · Hagerman, IDBuilt 2004 · S/N 1356-2003N496EMRegistration Pending · Mount Crawford, VARegistration pendingBuilt 2025 · S/N 82262N496EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12271N496GRegistration Pending · Orlando, FLRegistration pendingBuilt 1966 · S/N 1209N496HMTalon Air Service Inc · Soldotna, AKBuilt 1976 · S/N 17267496N496LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2022 · S/N 28020074N496MAEzboost LLC · Torrance, CABuilt 2005 · S/N 40.496N496MGRippy Gregg P · Glenwood Springs, COBuilt 1992 · S/N 1213N496SPWingsleasing LLC · Wichita, KSBuilt 1998 · S/N 172S8037N496TWalker Stephen E · Mcgregor, TXBuilt 1961 · S/N D-6684N496TPVertical Corporation · Kalispell, MTBuilt 1991 · S/N 1646N496WWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1931 · S/N 2023N497Mcrae Anna L · Kinder, LABuilt 1957 · S/N 24536N4970ANervino David J · Hilmar, CABuilt 1956 · S/N 32367N4970DMayes Nicholas R · Williams, CABuilt 1958 · S/N 51070
Back to AD 2007-04-19 R1