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.

N4948GTrece Inc · Adair, OKS/N 17273495N4948QWhite Ronald A · Anchorage, AKBuilt 1978 · S/N 18503583N4948RBlain Monte W · Joliet, MTBuilt 1975 · S/N 18802465N4948STaildragon LLC · Albuquerque, NMBuilt 1980 · S/N R18201487N4948URegistered aircraftBuilt 1965 · S/N 21058648N4949ASw Air LLC · Denver, COS/N 310R1505N4949ETrans Crafts LLC · Big Lake, AKBuilt 1979 · S/N 18503917N4949GFalcon Aviation LLC · South Saint Paul, MNBuilt 1979 · S/N 17273496N4949LLim Young Keun · Carthage, MOBuilt 1967 · S/N 28-4318N4949NCompass Rose Aviation · Derby, KSBuilt 1979 · S/N 18267474N4949PSonn Jeffrey R · Descanso, CAS/N 27-545N4949RValley Flying Service Inc · Orleans, NEBuilt 1975 · S/N 18802466TN494AStotlar William B · Pinckneyville, ILBuilt 1967 · S/N TE-370N494ABGluff Alan D · Franklin, INBuilt 2012 · S/N 91692N494AMOsprey Holding Company LLC · Foley, ALBuilt 1978 · S/N 17269969N494BEBig Ego Aerobatics Inc · Naperville, ILBuilt 1995 · S/N 5329N494CMLeadership In Training Education Inc DBA · Apollo Beach, FLBuilt 2000 · S/N 001N494DSBeulah Ltd Trustee · Wilmington, DEBuilt 2003 · S/N 40.294N494DWVieira Mark T · Turlock, CABuilt 2009 · S/N 001N494EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2015 · S/N 172S11602N494FLWilliams Mark J · Ojai, CABuilt 1971 · S/N 28-7125309N494HSale Reported · West Palm Beach, FLSale reported, pending cancellationBuilt 1975 · S/N 309N494JBD & S Aviation LLC · Spring, TXBuilt 2002 · S/N 172S9099N494JGGallagher Joseph Leo · Reno, NVBuilt 2017 · S/N 72712N494LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2021 · S/N 28020022N494LWWitte Steven E · Egan, SDBuilt 2011 · S/N 40667N494PGarrett Jacob Y · West Plains, MOBuilt 1993 · S/N CE-1738N494PCChristensen Darrel W Jr · Soldotna, AKS/N U20603156N494RJIsaacson Keith B · New Orleans, LABuilt 2009 · S/N E-3898N494RVBerthold Myles A · Belleville, ILBuilt 2006 · S/N 0002N494SHIhde Investments Lp · Red Oak, TXBuilt 2005 · S/N 10878N494SPInternational Air Services Inc Trustee · Carson City, NVBuilt 1998 · S/N 172S8035N494TMDuke Flight Training LLC · Bonnyman, KYBuilt 1975 · S/N 17265022N494TSDeep Creek Lake Ventures LLC · Oakland, MDBuilt 1983 · S/N T30300201N494WKingsbury Raymond S · Farmington, MNS/N 310K0103N494WAFly More Inc · Kawkawlin, MIBuilt 1978 · S/N 17271129N495495htsi LLC · Wilmington, DEBuilt 1980 · S/N 414A0487N4950DSimpson Darrell W · Soldotna, AKBuilt 1979 · S/N 17272408N4950HVaivadas Brian S · Bonney Lake, WABuilt 1981 · S/N 18267856N4950LDesimone Joseph L · Castle Rock, COBuilt 1967 · S/N 28-4320N4950RCivil Air Patrol Inc Natl Hdqtrs · Maxwell Afb, ALBuilt 1984 · S/N U20606810N4950UAerotech Mapping Inc · Las Vegas, NVBuilt 1979 · S/N U20605174N4950ZRiverside Tractor Inc · Friendswood, TXBuilt 1980 · S/N U20606055N49516Bresson Flying Service Inc · Compton, ILBuilt 1979 · S/N 15283467N4951FAerial Services Inc · Cedar Falls, IAS/N U206-0651N4951GMelbourne Flight Training LLC · Melbourne, FLBuilt 1979 · S/N 17273498N4951LMetcalf Linda G · Amarillo, TXBuilt 1967 · S/N 28-4321N4951NCactus Av8rs LLC · Gilbert, AZBuilt 1979 · S/N 18267476N4951PKnights Aviation Services LLC · Westlake, OHBuilt 1963 · S/N 27-547N4951TVolaero Aviation LLC · Valdosta, GAS/N 28R-7235161
Back to AD 2007-04-19 R1