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.

N342GLast Dean H · Mill Creek, WABuilt 1999 · S/N 3679N342HTrautman Michael · Hamilton, MTBuilt 1998 · S/N 1245-98N342JBCentral Ohio Flyers Association · Columbus, OHBuilt 1968 · S/N 17701033N342LSAutorotation Aviation LLC · Ardmore, OKBuilt 2013 · S/N 13474N342MAStauffer Michael S · Wichita Falls, TXBuilt 1996 · S/N 2843042N342MCCarra Michael J · Aiken, SCBuilt 2001 · S/N 1701N342MDCunningham Thomas J · New Braunfels, TXBuilt 2010 · S/N 2504N342MEAerostatics LLC · Gainesville, FLBuilt 2000 · S/N 18280738N342MJRohweder Alfredo R · Pompano Beach, FLBuilt 1991 · S/N 3144N342MKNorth Star Aviation Inc · Mankato, MNBuilt 2019 · S/N 2881260N342MLOrlowski Michael A · Gold Hill, NCS/N 343N342MMJohnson Aaron M · San Ramon, CAS/N 18258570N342MWHolway Stephen M · Gainesville, FLBuilt 1979 · S/N 18267144N342RAHeartland Aviation LLC · Harrisonville, MOBuilt 1978 · S/N 13119N342SHorn Travis L · Clarksville, ARBuilt 1969 · S/N E-189N342TAUnited States Air Force 60 Fss/Fsca · Rio Vista, CABuilt 2006 · S/N 2843645N342TTLewis Charles Ryan · Napa, CABuilt 2004 · S/N 1236N342UWelch Robert T · Alamogordo, NMBuilt 1971 · S/N D-9251N342WPPapa LLC · Eufaula, ALBuilt 1977 · S/N 28-7716288N342ZBaus Jordan M · Seattle, WABuilt 1960 · S/N CD-230N34302Romero John M · College Station, TXBuilt 1972 · S/N 17701757N34308Greenwood Kevin · Tucson, AZBuilt 1972 · S/N 17701759N3430FWingeier Dairy Farms · Alto, MIBuilt 1966 · S/N 18257430N3430LDachniwsky Holdings LLC · Southlake, TXBuilt 1974 · S/N 18263459N3430NKellner Darlene D · Lancaster, PABuilt 1967 · S/N 680050N3430PChamberlain Paul E · Troup, TXBuilt 1958 · S/N 23-1396N3430SBlue Skai Aviators LLC · Lawton, OKBuilt 1964 · S/N 18255830N3430TMeador Phillips H · Lexington, KYBuilt 1968 · S/N 17700730N3430WHerring Taylor R · Laredo, TXBuilt 1966 · S/N 32-291N34316Dane Ward LLC · Rising Fawn, GABuilt 1972 · S/N 17701764N3431LJacobs Brittany Lyn · Seattle, WABuilt 1966 · S/N U206-0731N3431RGuibaud Albert G · Monrovia, CABuilt 1967 · S/N 18258731N3431YMinor Joseph H · Hyannis, NEBuilt 1968 · S/N 18051931N34320Eagle Sky Patrol Inc · Deadwood, SDBuilt 1972 · S/N 17701766N34328Hamilton Thomas Arden · Lovettsville, VABuilt 1972 · S/N 17701767N3432FBierschwale Land Co LLC · Mason, TXBuilt 1977 · S/N 21062407N3432KPorte Elvis · Miami, FLBuilt 1967 · S/N 28-23552N3432MSears Megan · Rigby, IDBuilt 1977 · S/N 28-7816343N3432WNunak Air Taxi LLC · Kenai, AKBuilt 1966 · S/N 32-329N3433FVapor-Mist Sanitizing Systems · Boca Raton, FLS/N 18257433N3433PBolgar Mark S · Ewing, NJBuilt 1999 · S/N 420-99N3433RAlty It Solutions LLC · Milan, MIBuilt 1967 · S/N 18258733N3433SKah Gretchen Wendel · San Francisco, CABuilt 1964 · S/N 18255833N3433XRundus Timothy A · Chandler, AZBuilt 1966 · S/N 1125N3433ZKitchen Ronald L · Leasburg, MOFirst renewal noticeBuilt 1960 · S/N 22-7347N34343Wright Wayne M · Chestertown, MDBuilt 1972 · S/N 17701772N34346Ball Donald · Hatfield, PABuilt 1972 · S/N 17701774N34348Pingree Properties LLC · Hampshire, ILBuilt 1972 · S/N 17701775N3434FCoile Brantley · Athens, GABuilt 1990 · S/N 15N3434PNasair LLC · Flower Mound, TXBuilt 1958 · S/N 23-1401
Back to AD 2007-04-19 R1