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.

N53055Echo Lake Air LLC · Soldotna, AKBuilt 1974 · S/N 18502343N53057Endsley Gregory C · Sterling, AKBuilt 1974 · S/N 18502345N53059Smith Sidney R Trustee · Rllng Hls Est, CABuilt 1974 · S/N 18502347N5305ARathbun Daniel F · Odessa, TXBuilt 1983 · S/N 5009N5305BHamlin Curtis G · North Pole, AKS/N 33305N5305KJ M F And Associates Inc · Alexandria, VABuilt 1980 · S/N 17274055N5305LStearns Simon K · Edwardsville, ILBuilt 1968 · S/N 28-4607N5305NBennett Brian · Horseheads, NYBuilt 1980 · S/N 18267635N5305PMetzler Kevin W · Rosamond, CABuilt 1958 · S/N 24-346N5305VAmerican Academy Of Aeronautics Inc · Stanford, CAS/N 172RG0504N53065Cherry Hill Aviation LLC · Freetown, INBuilt 1981 · S/N 17274676N53068Legends Air Center LLC · Bentonville, ARBuilt 2002 · S/N 172S9265N53069Northwoods Air LLC · Orono, MEBuilt 1981 · S/N 17274678N5306CSo Cal Leasing LLC · El Cajon, CABuilt 2002 · S/N 172S9269N5306EN5306e LLC · Ashburn, VABuilt 1978 · S/N 17271832N5306GArno Christopher S · Dover Foxcroft, MES/N 21261N5306KMills Bradley W · Wichita Falls, TXBuilt 1980 · S/N 17274056N5306LRusch Steven A · Sequim, WABuilt 1968 · S/N 28-4608N5306RSheldon Scott H · Cohasset, MABuilt 1979 · S/N 172RG0051N5306UAircraft Solutions Group LLC · Englewood, COBuilt 2002 · S/N 172S9264N53070Wnc Aviation LLC · Arden, NCBuilt 2003 · S/N 172S9325N53077Megasky Holdings LLC · Charleston, SCBuilt 1981 · S/N 17274679N53078Proodian Kevin J · Wellington, FLBuilt 1982 · S/N 2270N5307BHunter Warren M · Rainelle, WVBuilt 1956 · S/N 33307N5307EHutton Douglas F · Elk City, OKBuilt 1958 · S/N D-5766N5307GBogen Alfred T III · Brandon, MSBuilt 1951 · S/N 22372N5307PDaniels Kevin · Bellingham, MABuilt 1958 · S/N 24-348N5307WWiley James E · Peace Valley, MOBuilt 1962 · S/N 28-359N53083Clearwater Potlatch Timber Protect · Orofino, IDBuilt 1974 · S/N 18502367N53087Colorado North Western Community College · Rangely, COBuilt 1981 · S/N 17274681N5308GEast Iowa Air Inc · Bennett, IABuilt 1951 · S/N 22829N5308LNelson John · Wichita, KSBuilt 1968 · S/N 28-4610N5308PRegistered aircraftBuilt 1958 · S/N 24-349N53092Reilly Patrick M · Anchorage, AKBuilt 1974 · S/N 18502371N5309BKadlubowski Michael J · Colorado Springs, COBuilt 1956 · S/N 33309N5309DPotter John · Payson, UTS/N 50207N5309GMarshall Randall · Addison, TXBuilt 1951 · S/N 21656N5309JRegistered aircraftRegistration pending, pending cancellationS/N 17273759N5309LTexasflight3000 Holdings LLC · Crossroads, TXBuilt 1968 · S/N 28-4611N5309PJabalera Josh M · Billings, MTBuilt 1958 · S/N 24-350N5309VFlight Training Aircraft LLC · Wilmington, DEBuilt 2002 · S/N 172S9274N530AUWateractive43 LLC · Auburn, CABuilt 2002 · S/N 172S9225N530BWWhitehead William C · Mills River, NCBuilt 2018 · S/N 1236N530CContinental Title Trust LLC Trustee · Wichita, KSBuilt 1976 · S/N D-9927N530CFFitzgerald Carson W · Mckinney, TXBuilt 2006 · S/N 293N530CJMyers Russell S · Spangle, WABuilt 2009 · S/N 75N530ESki N Sky LLC · Leesburg, VABuilt 2003 · S/N 0575N530ERZima Aviation LLC · Huntington, CABuilt 2002 · S/N 172S9113N530GGSmith Jason · Calliham, TXBuilt 2013 · S/N 13430N530HSCti Aircraft Leasing LLC · Memphis, TNBuilt 2014 · S/N 1205
Back to AD 2007-04-19 R1