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.

N4824GHickman Robert B · La Follette, TNBuilt 1979 · S/N 17273372N4824SWilly Jack LLC · Wickenburg, AZBuilt 1970 · S/N 32-1255N4825ATodd Gary W · Rogers, OHBuilt 1956 · S/N 22-3978N4825DHitec Construction Services Inc · Lincoln, CABuilt 1958 · S/N 34925N4825EParis Enterprises LLC · Atlanta, GABuilt 1979 · S/N 18503883N4825NBlue 79 LLC · Loogootee, INBuilt 1979 · S/N 18267397N4825YHall William B · Vincentown, NJBuilt 1968 · S/N 25-4614N4826DTurbine Training Center Inc · Manhattan, KSBuilt 1958 · S/N 34926N4826SQuill Sean · Hadley, MABuilt 1969 · S/N 32-1257N4826TSundance Air Services Inc · Alameda, CAS/N 28-7205202N4827DWebber David A · Delta Junction, AKBuilt 1958 · S/N 34927N4827LDes Moines Flying Club · Indianola, IABuilt 1967 · S/N 28-4170N4827PCarlson Chris · Redwood City, CABuilt 1978 · S/N P21000119N4827SMckemy Michael L · Joppa, MDBuilt 1969 · S/N 32-1258N4827UHagen Rainer · Irving, TXBuilt 1979 · S/N U20605119N4827YThief River Aviation Inc · Thief River Falls, MNBuilt 1968 · S/N 25-4618N4828DNisbet William T · Driggs, IDBuilt 1958 · S/N 34928N4828HWilson Aviation Club LLC · Wilmington, DEBuilt 2006 · S/N 11236N4828KFlywerx LLC · Anchor Point, AKBuilt 1979 · S/N P21000336N4828LMcmordie Frank F IV · Dallas, TXBuilt 1967 · S/N 28-4171N4828PFlying Nam LLC · Sheridan, WYBuilt 1981 · S/N 17274828N4828SPuerto Rico Aircraft Leasing Corp · Ceiba, PRBuilt 1969 · S/N 32-1259N4828TSun Star Holdings LLC · Binghamton, NYBuilt 1972 · S/N 28-7205203N4829GSoaring Raven LLC · Seattle, WABuilt 1979 · S/N 17273377N4829JMidwest Aircraft Services Inc · Wilmington, DEBuilt 1966 · S/N CE-117N4829KCanal Flight LLC · Portland, ORBuilt 1979 · S/N P21000337N4829LHoughton Robert E · North Ferrisburgh, VTBuilt 1967 · S/N 28-4172N4829NKcj Fly LLC · Fuquay Varina, NCBuilt 1979 · S/N 18267399N4829RThomas Michael W · Prescott, WABuilt 1978 · S/N R18200614N4829TMaples David R · Diamondhead, MSS/N 28-7205204N482AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843748N482ACClarke Jonathan Eric · Eustace, TXBuilt 1999 · S/N 428-99N482AMWarner Robins Air Service · Cochran, GABuilt 2004 · S/N 2282N482ASPlatt Drey D · Sahuarita, AZBuilt 1968 · S/N 28-25252N482CACivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282142N482CCMitchell Timothy K · Dunnellon, FLBuilt 1967 · S/N 28-4165N482CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2005 · S/N 1482N482CPCivil Air Patrol · Montgomery, ALBuilt 2010 · S/N 18282263N482CSTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13482N482DTCavorite Aviation LLC · Lehi, UTS/N 28-8490071N482EHb Coco & Company · Gonzales, TXBuilt 1979 · S/N 17272338N482EJDavis Douglas L · Everson, WABuilt 1953 · S/N 20-1052N482EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12252N482FLJacobs Mark W · Browning, MTBuilt 1971 · S/N 28-7125288N482KBBethune Kenneth · Huntsville, ALBuilt 2021 · S/N ES-138N482MBSmith Thomas W · Wall Township, NJBuilt 1984 · S/N 32-8406015N482NBCline Braxton L · Wasilla, AKBuilt 2025 · S/N BC0031N482PSinsaja Holdings LLC · Sheridan, WYBuilt 1965 · S/N 28-2728N482TWT34 Mentor LLC · Saint Joseph, ILBuilt 2017 · S/N 18283006N4830ARenick Tyler Cain · Wichita Falls, TXS/N 22-3983
Back to AD 2007-04-19 R1