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.

N4578TMeditz Robert S · Chalfont, PABuilt 1972 · S/N 28R-7235097N4579Kinney Joseph B · Palmer, AKBuilt 2023 · S/N 01946N4579FWagner Jan W · Lopez Island, WAS/N 185-1086N4579JSnagwood Corp · Brentwood, CABuilt 2012 · S/N 5819N4579NSeven Eight Juliet LLC · Edmond, OKBuilt 1978 · S/N 340A0479N4579RSmelser Brady W · Glendive, MTBuilt 1965 · S/N 28-21321N4579TNavajo Air LLC · Scottsdale, AZBuilt 1972 · S/N 28R-7235098N457ACBrown David R · Niceville, FLBuilt 1999 · S/N 414-99N457AGSkywest Leasing Inc · St George, UTBuilt 2024 · S/N 2881757N457ARPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010057N457BBRlm Investment Holdings LLC · Wilmington, NCBuilt 1994 · S/N TH-1712N457BCMorris Thomas Z Trustee · Spokane Valley, WABuilt 1974 · S/N 17264589N457CDAloha Helicopter Tours LLC · Lihue, HIBuilt 2012 · S/N 13302N457CFHelliwell Anne · Sun City, CAS/N 08N457CMIasco Flight Training Inc · Redding, CABuilt 2000 · S/N 17280849N457CWRockin Mc Helicopter Services LLC · Missoula, MTBuilt 2013 · S/N 13542N457DFUsda Forest Service Fepp · Mcclellan, CABuilt 1982 · S/N TH-1354N457DHRichardson Justin · Glasgow, KYBuilt 1998 · S/N 20457N457DKMiller Gordon J Jr · Monaca, PABuilt 2003 · S/N 29-0313N457DLLeis Donald E · Greenville, OHBuilt 1970 · S/N 18260404N457DMMajor Development LLC · Cedaredge, COBuilt 1978 · S/N 340A0554N457DTMathew Reggie T · Satellite Beach, FLBuilt 1997 · S/N E-3095N457EPRainier Flight Service LLC · Renton, WABuilt 2015 · S/N 172S11593N457GHStephenson George B · Santa Fe, NMBuilt 2018 · S/N 72784N457JNToerner Investments · Findlay, OHBuilt 1975 · S/N D-9807N457MCBoguy Air LLC · Kingstree, SCBuilt 1974 · S/N 466-74N457MSNesk Aviation LLC · Orlando, FLBuilt 1979 · S/N E-1523N457PAIdeal Aviation Illinois LLC · Sauget, ILBuilt 2019 · S/N 1247N457PMHordiienko Yurii · Boston, MABuilt 2018 · S/N 2108N457RBHale Francis J III · Raleigh, NCBuilt 1990 · S/N 1457N457SKWorld Marketing Syndicate I · Wilmington, DEBuilt 1975 · S/N 17264736N457SPSouth Dakota State University · Brookings, SDBuilt 1999 · S/N 172S8321N457TThompson Ernest W Jr · Yukon, OKBuilt 1976 · S/N 28-7690218N457TCLangston Thomas G · Weatherford, TXBuilt 2014 · S/N 785N457WTBlair Aviation LLC · Essex, MOBuilt 2008 · S/N 12480N4580EDe Baca Land & Cattle LLC · Jacksboro, TXBuilt 1982 · S/N 18268244N4580FRegistered aircraftBuilt 1976 · S/N 28-7790045N4580JBlakeslee Mark C · Kodiak, AKBuilt 1975 · S/N 180-52509N4580KHarrah Daniel R · Juneau, AKBuilt 1979 · S/N P21000223N4580RMartin James E · Rostraver Township, PABuilt 1966 · S/N 28-21322N4581JN634mm LLC · Pelham, ALBuilt 1968 · S/N 28R-30450N4581SDaum Jeffrey A · Ocala, FLBuilt 1975 · S/N D-9808N4581XRegistered aircraftBuilt 1975 · S/N 28-7690042N45829Registered aircraftBuilt 2004 · S/N 28020CN4582AHart Duane L Trustee · Wasilla, AKS/N 18-4888N4582ERelis Enterprises LLC · Ravenel, SCBuilt 1982 · S/N 18268245N4582JTew-Mac Aviation · Tewksbury, MABuilt 1968 · S/N 28R-30451N4582RMartin Robert T · Huntsville, OHBuilt 1965 · S/N 28-21324N45832Arenal Patrick T · Granbury, TXBuilt 1977 · S/N 28-7890048N4583RDmac Aircraft LLC · Savannah, GABuilt 1965 · S/N 28-21325
Back to AD 2007-04-19 R1