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.

N356DPMid America Aircraft LLC · O Fallon, ILBuilt 1978 · S/N 32R-7885158N356DSRsmaviation LLC · Templeton, CABuilt 2004 · S/N 3486PN356DWWeiss Bernard J Trustee · Saint Paul, MNBuilt 2000 · S/N 2101N356GTPadre Bendice Este Vuelo LLC · Groveton, TXBuilt 1998 · S/N 1850N356JBBokash Greg · Bridgeton, NJBuilt 2002 · S/N 1334-2002N356JTHorizon Aviation LLC · Mobile, ALBuilt 1960 · S/N 18253096N356MU S Department Of The Interior · Boise, IDBuilt 2014 · S/N CC18-0072N356MKNorth Star Aviation Inc · Mankato, MNBuilt 2021 · S/N 2881503N356MTGlasscock David L · Lakewood, COBuilt 1965 · S/N 28-21274N356NDAir Shares LLC · Casper, WYBuilt 2003 · S/N 2842184N356PCGreen Seth M · Kissimmee, FLBuilt 1998 · S/N PCD-001N356PVDalton Steven J · Plano, TXBuilt 1973 · S/N AA5-0303N356TAFlyktoc LLC · Lavonia, GABuilt 1976 · S/N 172-67123N356TBSky West Aviation Inc Trustee · Albuquerque, NMS/N 1709N356VAVictory Aviation Club Inc · Hamilton, OHBuilt 1981 · S/N 32-8206008N356WBMwm Interests Inc · The Woodlands, TXBuilt 2009 · S/N 261N35700Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1968 · S/N 17256916N35701Mcha Aviation LLC · Vinita, OKBuilt 1968 · S/N 17256917N35705Paris Air Inc · Vero Beach, FLBuilt 1979 · S/N 28-8016207N35707Pray Aviation Inc · Augusta, KSBuilt 1968 · S/N 17256921N3570EBlackbird Aviation Corp · Van Nuys, CAS/N 17271593N3570UDoyle Neil R · North Pole, AKBuilt 1963 · S/N 18254970N35711Pumphrey Robert B Jr · Saint Paris, OHBuilt 1968 · S/N 17256925N35712Mw Flying LLC · Sanford, NCBuilt 1968 · S/N 17256926N3571335713 LLC · Kitty Hawk, NCBuilt 1968 · S/N 17256927N35714Skyhawk Rising LLC · Manchester, IAFirst renewal noticeS/N 17256928N35715Kindblade Aeronautics LLC · Casper, WYBuilt 1968 · S/N 17256929N35716Ward Seth W · Demorest, GABuilt 1968 · S/N 17256930N35718Parmerlee David · Grand Rapids, MIBuilt 1979 · S/N 32R-8013032N35719Jensen Greg D · Omaha, NEBuilt 1968 · S/N 17256932N3571GMid Continent Aircraft Corp · Hayti, MOBuilt 1964 · S/N 1080N3571LPeltier Scott M · Longwood, FLS/N 28-8011071N3571NCoker Steve L · Tyler, TXBuilt 1967 · S/N 680101N3571PRegistration Pending · Myrtle Beach, SCRegistration pendingBuilt 1979 · S/N 28-8011069N3571WJtw Financail Services · Norfolk, NEBuilt 1966 · S/N 32-463N3571YIllinois Valley Parachute Club · Carlock, ILBuilt 1962 · S/N 18254471N3571ZThompson Lyndon R · West Fargo, NDBuilt 1960 · S/N 18-7349N35725Kling Jonathan N · Ruther Glen, VABuilt 1968 · S/N 17256936N35726Jh Aero LLC · Little Rock, ARS/N 17256937N35728Gone Broke LLC · Fairhope, ALBuilt 1968 · S/N 17256939N3572ADavis Robert D · Independence, ORBuilt 1969 · S/N TC-1306N3572BPiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 32R-8013033N3572GHauser Linda · Ulysses, KSBuilt 1964 · S/N 1081N3572MPlane Nonsense Inc · Middletown, DEBuilt 1978 · S/N 28-7816356N3572PMulkey Joshua D · Anchorage, AKS/N 18-4526N3572QFloyd Richard C · Sutter Creek, CABuilt 1973 · S/N 17261676N3572UFrappollo Paul M · Berryville, VABuilt 1963 · S/N 18254972N3572XKelsoe Gregory Lyle · Clermont, FLBuilt 1979 · S/N 28-8016213N35730Miner Jay G · Seattle, WABuilt 1968 · S/N 17256940N35731Registration Pending · Carthage, NCRegistration pendingBuilt 1968 · S/N 17256941
Back to AD 2007-04-19 R1